Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the following Date as a String:
01/08/2016 03:00 (DD/MM/YYYY hh:mm)
What I need is to convert it to Date in order to show the month like this: August
Do you know how to do that?
Thank you!
May be as below:
May be like this:
Date(Date#(DateField, 'DD/MM/YYYY hh:mm')) as Date,
Month(Date#(DateField, 'DD/MM/YYYY hh:mm')) as Month,
Date(MakeDate(Year(Today()), Num(Month(Date#(DateField, 'DD/MM/YYYY hh:mm'))), 1), 'MMMM') as FullMonthName