You can use DateAdd
For TimeStamp DateAdd("s", lngRemedyDate, #1/1/1970#)
Since Time fields are stored as Seconds since Midnight try:
For Time DateAdd("s", lngRemedyTime, Date)
Date Fields are stored as the number of days since January 1 4713BC try:
For Date DateAdd("d", lngRemedyDate-2440588, #1/1/1970#)
I know the 1st works, I'm guessing on the last 2
Fred
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]
On Behalf Of Henry Vaughn
Sent: Friday, November 07, 2008 11:13 AM
To: [email protected]
Subject: Access Time Function
Does anyone have the formula for converting time in MSAccess.
