Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Dear Prince,
Its working fine Thanks for Suggest.
Regards,
Khasim.
Welcome