My date is in the form of 31/01/2017. I want to format it as 31-Jan. How do I do it?
This doesn't work. There is an error.
=date(date#(=maxstring({[Date1]} [DATE]),'DD/MM/YYYY'), 'DD-MMM')
Answer
Function Date#() returns the expression as a date according to the string given as format-code. If the format code is omitted, the default date format set in the operating system is used.
Syntax:-
Date# (text [, format])
After that use Date function to convert it to date. Let's look at below example:-
Example:-
=Date(Date#('16JAN2014','DDMMMYYY'))
Above we have converted character format of date to date using date# and date functions.
Your Example:
I am confused what are you doing here. Just check (=maxstring({[Date1]} [DATE]),'DD/MM/YYYY') and check is Date1 matching 'DD/MM/YYYY' format.
And put it your date conversion format.
=date(date#( (=maxstring({[Date1]} [DATE]),'DD/MM/YYYY') , 'DD-MMM'))