Date format change?

[#1]

Hi I have one date column year in my excel data

like

Apr 2014

June 2014

July 2014

Now i want to cnvert this into date format  like  Apr-2014

  please help me on that.

[simenkg]

Date(MonthYear,'MMM-YYYY')

[tresesco]

If your this date field is not a proper date field, you might have to try like:

Date(Date#(YourDateField, 'MMM YYYY'), 'MMM-YYYY') as NewDate

And yes, now I note that your date format is not uniform, somewhere three-letters;somewhere four-letters for month. They are expected to be uniform with three-letters.

[ashfaq_haseeb]

Hi,

try below

Date#(MonthYear,'MMM-YYYY')

or

Date(Date#(DateFieldName, 'MMM YYYY'), 'MMM-YYYY')

Regards

ASHFAQ

[jagan]

Hi,

Try like this

=Date(Date#(DateFieldName, 'MMM YYYY'), 'MMM-YYYY')

Regards,

Jagan.

[#6]

Hi ,

iam not getting any data as per your expresson

actually the data is not in date format.

first i need to change

Jan 2014

Apr 2014

above data into date format

is there any way to change above data into date format

[jagan]

Hi,

Date() and Date#() function to convert the date format, refer my previous post for solution.

Regards,

Jagan.