Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to convert the Date from 'DD/MM/YYYY' to 'DD MMM YYYY'.
My date here is 9/1/2017 (DD/MM/YYYY), when I try to convert to 'DD MMM YYYY', I get '01 Sep 2017' instead of '09 Jan 2017'. If I have 31/1/2-017 I don't see any date when I use 'Monthname' function.
Did anyone come across this kind of scenario?
Thanks in advance!
Cheers,
Varun
Hi,
Change the Default Date format as below
SET DateFormat='D/M/YYYY';
LET vDate = Date('9/1/2017','DD MMM YYYY');
Hi:
1 Example:
=Date(Date#('9/1/2017','D/MM/YYYY'),'DD/MMM/YYYY')
Hi fer,
Thanks for the quick response. It worked. What was the issue?
Cheers,
VK
Hi Krishna Priya,
Thanks for your quick response. It is still showing the same issue.
Cheers,
VK
Hi,
Try below
=Date(Date#(Datefield, D/MM/YYYY'),'DD/MMM/YYYY') as newdate
Hi Varun,
Whenever you need to change date from one format to another than better use Date# function.
=Date(Date#('9/1/2017','D/MM/YYYY'),'DD/MMM/YYYY')
Regards
Deepak