Parameter Date formatting

[rubinap]

Hi,

I am using Crystal Reports 9.0. I am accepting a date as a parameter & want to convert it to a number - (AS400- Database ) 'YYYYMMDD' - how do I do it?

the date format is 8/30/2005 - I cannot use mid function as the month can be 8 or 10 .. Is there anyother way of working around this?


Rubina

 

[lbass]

You could use:

tonumber(totext({table.date},"yyyyMMdd"))

-LB

 

[lbass]

Sorry, that should have been:

tonumber(totext({?date},"yyyyMMdd"))

-LB