Need help in 'Date' Formula

[Former Member]

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

[Former Member · Accepted solution]

You can use Amr Salem's reply will help you to solve this.

You can use the following formula also:

ToText(Datetime({?date}), "MM-dd-yyyy")

I hope this solves your query!!

Regards,

Parsa.

[Former Member · Accepted solution]

Hi Ramesh,

Thanks a lot !! It definetely solved my problem ....

Hi Amr,

i was using the formula to display a dynamic header content.. thats why i was using formula .. Thanks for your response..

Meena