Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
how to get date format .
and i am using this date(date#([Due Date],'DD-MMM-YYYY'),'MMM-YYYY') AS MonthYear1 not getting correct
output.
to Ex: Jan-2017
thanks ,
Can you please give a few sample values from 'Due Date' in one excel file?
This is only solution i can understand in the situation:
UPPER(Date(Date#([Due Date],'DD-MM-YYYY'),'MMM-YYYY'))as MonthYear1
After reload what you get in MonthYear1 field?
i am getting empty year and month.
I did the same and i have the attached result.
attach it and snd me pls.