Date format Problem in Qv Scripting?

[khasimvali85]

Hi Community,

                         Can anybody give the solution for the given date format?

i have the date field like give below, i wanna show format(DD/MM/YYYY)

   Date:

--------------

2014.05.09

2014.05.10

2014.05.11

2014.05.12

2014.05.13

I given date function like Date(Date_field,'DD/MM/YYYY') as Date_field

but its not working any solution for this?

Regards,

Khasim.

[#2 · Accepted solution]

Dear Khasim,

Use the following function in Script:-

date(date#(Date_field,'YYYY.MM.DD'),'DD/MM/YYYY') as Date_field

Thanks & Regards

Prince Anand

[khasimvali85]

Dear Prince,

                    Its working fine Thanks for Suggest.

Regards,

Khasim.

[#4]

Welcome