Displaying the date in dd/mm/yyyy format

[Former Member]

Hi,

In VC 7.1, Whenever the user selects the date from the calender it is displayed in mm/dd/yyyy format .but i want it to be displayed in dd/mm/yyyy format.please help me.

Regards,

Priya

Edited by: priya on Oct 7, 2008 11:01 AM

[Former Member]

Hi

Try using the DSTR Dynamic Expression function. Add a string field to your form or table and format it using the DSTR function.

It should look something like "=DSTR(@CREAT_DATE,"DD/MM/YYYY")"

You can find more information about date conversion functions in the [Date and Time Functions help page|http://help.sap.com/saphelp_nw70/helpdata/en/2b/6c37121f28462a8710c0c7493506dd/frameset.htm]

Regards,

Shai

[Former Member]

Hi Shai,

Thanks for your reply.i dont want to convert the date field to string.The date shoud have the dd/mm/yyyy format in the date type element only.is there anyway to do that?