Converting timestamp to month and year

[vinod2086]

Hi All,

i have a Created date which is coming from source system.

NewDate

01-04-2018 00:00

01-04-2018 00:01

01-04-2018 00:02

01-04-2018 00:03

01-04-2018 00:04

04-04-2018 20:44

04-04-2018 20:45

07-04-2018 22:38

07-04-2018 22:39

here i would like to convert newdate into Year and month.(2018/01--)

Please help me

[sunny_talwar]

May be this

Date(MonthStart(NewDate), 'YYYY/MM') as YearMonth

or

Date(MonthStart(Date#(NewDate, 'DD-MM-YYYY hh:mm')), 'YYYY/MM') as YearMonth

[Thiago_Justen_]

Another tip:

MonthName(Date#(NewDate))

[renuka_sasikumar]

The Second one is working for me.

Date(MonthStart(Date#(NewDate, 'DD-MM-YYYY hh:mm')), 'YYYY/MM') as YearMonth

Thank You.