Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Date(MonthYear,'MMM-YYYY')
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.
Hi,
try below
Date#(MonthYear,'MMM-YYYY')
or
Date(Date#(DateFieldName, 'MMM YYYY'), 'MMM-YYYY')
Regards
ASHFAQ
Hi,
Try like this
=Date(Date#(DateFieldName, 'MMM YYYY'), 'MMM-YYYY')
Regards,
Jagan.
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
Hi,
Date() and Date#() function to convert the date format, refer my previous post for solution.
Regards,
Jagan.