Creating Date field from numeric YYYYMMDD

[Reebo99]

Hello everyone,

Not sure if people are aware you can do this, but it helps me a whole lot.

If you have a Numeric field YYYYMMDD or 20030101 then rather than using :

date(left(totext(20030101,0),2),mid(totext(20030101,0),5,2),right(totext(20030101,0),2))

Use :

Date(ToText(20030101,"####,##,##&quot)

Works a treat! Reebo
Scotland (Going mad in the mist!)

 

[dgillz]

Better yet, download the free UFL on the crystal decisions website for the NumbertoDate() function.

Numbertodate() takes an 8 digit interger in a YYYYMMDD format and converts it to a "real" date.

Macola and ACCPAC are 2 of the programs that I have run into that uses this date format stored as a number, but I am sure there are others. Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com