Remedy dates in Access

[Lourry]

Hello All,

Has anyone successfully convert Remedy dates into readable format that appears in Access textboxes without using Remedy ODBC to do the conversion?

Thanks a lot!
-Lory

 

[kramerica]

Have you tried format(fieldname,"MM/DD/YYYY")...

just throwing that out there, I don't use remedy.

Can you post a sample of how the remedy data is displayed?

Kramerica

 

[Lourry]

The ARS stores dates as number of seconds since 1/1/1970 in Universal or GMT time.

so 792258604 is actually 2/8/1995 10:50:04 AM

currently the textbox on my Access 97 form is getting data from a Oracle database and it is just displaying 792258604. But I would like it to display 2/8/1995 10:50:04 AM or something similar to this.

ANy ideas?
Thanks in advance!
-Lory

 

[Lourry]

I've got it working from the following code:

newDate = CVDate(CDate("1/1/1970 12:00:00AM") + ((num - 18000) / 3600) / 24)

BUT....how to take care of the DST? (Daylight Saving Time) the +/- one hour...

Any ideas?
Thanks again!