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

[amrsalem1983]

you can use the direct formats, you dont need to create a formula

just put the date field in the report design, and then right click, and then select "Format Field"

select the format do you want, or click "Customize" for custom formats

good luck