Skip to Content
0
Former Member
Aug 12, 2008 at 03:40 AM

Need help in 'Date' Formula

28 Views

Hi All,

i have an input parameter of datatype 'Date'. The format of the parameter is 'mm/dd/yyyy' (selected from calendar control).

Now i need to display this in 'mm-dd-yyyy'.

i used the below formula:

ToText ({?dat},"MM-DD-YYYY");

The Result is 08-DD-YYYY for the input parameter 08/01/2008.

Kindly help me with the formula.

Thanks,

Meena