Still Struggling 1

[mdctsg]

I am still searching for a way to convert my access database date time stamp to date. In my db the date comes in yyyymmddhhmmss or 20020614151325. I would like to be able to convert this date so I can use the date picker on it. Any ideals would be great.

Thanks
Bob

 

[dgillz]

If you just want to convert it to a date, then this formula should work:

NumberToDate(ToNumber(Left(ToText(20020614151325,0,"&quot,8)))

NumberToDate is available as a UFL downloadablr from the CD website and it converts any 8 digit integer in a YYYYMMDD format to a date.

I can email you this UFL if you would like it. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com