how to get date format

[sannidhikumar]

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 ,

[shanky1907]

Can you please give a few sample values from 'Due Date' in one excel file?

[sannidhikumar]

[shanky1907]

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?

[sannidhikumar]

i am getting empty year and month.

[shanky1907]

I did the same and i have the attached result.

[sannidhikumar]

attach it and snd me pls.