Date ()

[Karahs]

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_talwar]

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

[Karahs]

Hello Sunny,

I tried doing this but it comes as blank

[shraddha_g]

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.

[jonathandienst · Accepted solution]

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')

[Karahs]

Thankyou Jonathan , even Sunny was right had a period instead of a colon for date separator.