Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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')
May be this:
Date(MaxString({[Date1]} DATE), 'DD-MMM')
UPDATE: or this
Date(Max({[Date1]}Date#(DATE, 'DD/MM/YYYY')), 'DD-MMM')
Did you try like?
Date(Date#(yourDate, 'DD/MM/YYYY'), 'DD-MMM')
=Date(Date#( [DATE], 'DD/MM/YYYY'), 'DD-MMM')