Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
i have date in following format 07/09/2016 08.55 PM need to find the month and year for the following date.Made use of the Function Month(),Year(), Date(Date#([Date field], 'dd/MM/yyyy hh.mm pp'), 'M/d/yyyy') as open_Date but all are giving blanks.Can anyone Suggest?.
Thanks in advance!!
Sunny is correct, except I think you have a period instead of a colon for a date separator.
=Date(Date#([Date field], 'dd/MM/yyyy hh.mm TT'), 'M/d/yyyy')
Try this:
Month(Date#([Date field], 'dd/MM/yyyy hh:mm TT')) as Month,
Year(Date#([Date field], 'dd/MM/yyyy hh:mm TT')) as Year,
Date(Floor(Date#([Date field], 'dd/MM/yyyy hh:mm TT'))) as Date,
TimeStamp(Date#([Date field], 'dd/MM/yyyy hh:mm TT')) as TimeStamp
Hello Sunny,
I tried doing this but it comes as blank
Try:
month(date(floor(TImestamp#([Date field],'DD/MM/YYYY hh.mm TT')))) as Month,
year(date(floor(TImestamp#([Date field],'DD/MM/YYYY hh.mm TT')))) as Year
I hope it is helpful.
Sunny is correct, except I think you have a period instead of a colon for a date separator.
=Date(Date#([Date field], 'dd/MM/yyyy hh.mm TT'), 'M/d/yyyy')
Thankyou Jonathan , even Sunny was right had a period instead of a colon for date separator.