Issue with Date format

[varunreddy]

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

[krishnacbe]

Hi,

Change the Default Date format as below

SET DateFormat='D/M/YYYY'; 

LET vDate = Date('9/1/2017','DD MMM YYYY');

[el_aprendiz111 · Accepted solution]

Hi:

1 Example:

=Date(Date#('9/1/2017','D/MM/YYYY'),'DD/MMM/YYYY')

[varunreddy]

Hi fer,

Thanks for the quick response. It worked. What was the issue?

Cheers,

VK

[varunreddy]

Hi Krishna Priya,

Thanks for your quick response. It is still showing the same issue.

Cheers,

VK

[Chanty4u]

Hi,

Try below

=Date(Date#(Datefield, D/MM/YYYY'),'DD/MMM/YYYY')  as newdate

[#7]

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