Re: Format Informix date -> Access

Gareth Oliver wrote: > > Hi there > > I am tyring to report dates from Informix 7.12 via MS Access v2.0 on > Windows 3.1 client. > > Informix holds dates in the number of seconds from 01/01/70 12:00:00. > > What I would like Access to do be able to report a date field direct > from the Informix database, however formatting it to be able to read. > > i.e. at the moment March 21, 1997, 12:06:41 is being reported as > 858902801. > > Has anyone been able to do this? The only recommendations I can find > from people are to create another field & add it to as text. I don't > want to do this as the schema as very large as it is. > > Thanks for you rhelp. > > Regards, > Gareth Gareth, It sounds like you're talking about the Informix datetime data type, not the date datatype... The date data type is stored as the number of days since 12/31/1899. In any case, when you do your conversions, you should be able to use a "using" clause to assign your Informix data to variables in any format you like. For example you might do something like this: let ms_access_variable = informix_variable using "MM/DD/YY" That should do the trick. If you need time formats, there are some available (check the Informix documentation for the formats... I've not used time formats in a while, and I'd hate to give you bad information). HTH. Dan Michaelis Client Information Manager, Dede Wallace Center