how to convert data mmyyyy format to mmmyyyy

[#1]

how to convert date in 072014 to jul 2014 format...

[MK_QSL · Accepted solution]

Date(Date#('072014','MMYYYY'),'MMMYYYY')

or

Date(Date#('072014','MMYYYY'),'MMM YYYY')

or

Date(Date#(YourFieldName,'MMYYYY'),'MMMYYYY')

or

Date(Date#(YourFieldName,'MMYYYY'),'MMM YYYY')

[PrashantSangle]

Hi,

use date(date#(fieldName,'MMYYYY'),'MMM YYYY')

REgards

[suresh_rawat]

Hi,

By using Dae# function you can change the format of your date.

For Example :- date(Date#(Dispatch_Date_Time,'YYYYMMDD'),'MM/DD/YYYY')

Hope this will work for you.

Regards

Suresh Rawat

[suresh_rawat]

For Example :- date(Date#(Your_Date,'YYYYMMDD'),'MM/DD/YYYY')

[suresh_rawat]

Hi,

Above date formation is for complete date change.

As per your requirement use this format.

date(date#(fieldName,'MMYYYY'),'MMM YYYY')

Regards

Suresh Rawat