Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Converting a YYYYMMDD number to a date

Formula Help

Converting a YYYYMMDD number to a date

by  dgillz  Posted    (Edited  )
There are a number of databases that store their dates as an 8 digit integer in a YYYYMMDD format. For those faced with this dilemna, there is a UFL available from Business Objects that will convert this to a real date.

NumberToDate(20030506) will return 5/6/2003, a real date.

The link to this UFL is here:

http://support.businessobjects.com/communityCS/FilesAndUpdates/ufltdate.exe.asp

Just install this UFL, and the NumberToDate() function should appear in crystal under additional functions.

Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top