I'm at Wit's End

[kh59743]

I can find plenty of help on converting a date (1/1/2005) to a serial number, but how do I reverse the process? I'm importing data from another program that stores dates as serial numbers. If I use the Date() function in Crystal Reports, it converts fine, but I'm not having the same luck in Access.

Any recommendations would be greatly appreciated. Thank you.

 

[KenHigg]

I can see where Date() will not work - That basically returns the current date. Have you looked at the FormatDateTime() function?

 

[kh59743]

Thanks for the suggestion.

I tried looking up some information about that function and couldn't find any, so I went ahead and tried it using the date's serial number as its only argument. Unfortunately, the result was an #Error message.

Do you have any other ideas? Or know where I could find more about this particular function and its arguments?

Thanks!

 

[KenHigg]

Did you look in VBA Help instead of regular Access Help?

 

[The_Doc_Man]

One trick that SOMETIMES works is to add a reference to Excel in your References list. (Open Module, menu bar Tools >> References)

Once Excel is there, you can call its functions if you wish. Including the one that would reverse your date-serial computation.