Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I change the date from '01/01/2016' to 'January 2016' format?
You can use a format code like 'MMMM YYYY' with a date() formatting function or as default date format code:
Date(DATEFIELD, 'MMMM YYYY')
Try this
Date(monthstart(Date), 'MMMM-YYYY') as MonthYear
You can use MMMM or MMM and will depend on your environmental variables.
If you have this:
SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';
Then Date(MonthStart(Datefield), 'MMMM YYY') as Datefield
In case your have this:
SET MonthNames='January;February;March;April;May;June;July;August;September;October;November;December';
Then Date(MonthStart(Datefield), 'MMM YYY') as Datefield or MonthName(Datefield) as DateField
It all depends on your ability and willingness to change the environmental variable. If you have access to the script and are willing to make a change, I would suggest using the second option with MonthName() function.
Best,
Sunny