CODEWITHSUNDEEP
crystal-reports
user1749640
user1749640

Reputation: 27

How to convert the current date to a numeric value in Crystal Reports

Example: i like to convert the currentdate into a numeric value like YYYYMMDD. Thanks for your help.

Upvotes: 1

Views: 13117

Answers (1)

Hariharan Anbazhagan
Hariharan Anbazhagan

Reputation: 1329

Try using the following formula
tonumber(totext(currentdate,'yyyyMMdd'))
This formula will convert your Current Date to YYYYMMDD format and the field will be a Numeric Field.
Hope this helps !!

Upvotes: 4

Related Questions