date format issue?

[daisy1438]

Hi

I have date field with time stamp.

mydate:

29/03/2018 22:38:10

29/03/2018 22:42:19

29/03/2018 22:44:10

08/04/2018 09:32:14

08/04/2018 10:38:19

08/04/2018 12:39:07

14/05/2018  08:55:18

14/05/2018  10:56:16 like that.

my requirement is first i need to create the month field.above date it is available 3 months and each month having multiple date because time stamp.so i need to create only one date instead of 3 dates.like below

Month:

MAR-2018

APR-2018

MAY-2018

JUN-2018  like that,how to achieve this.

I am writing the exp in script level for month field like

date(floor(date(mydate,'DD/MM/YYYY hh:mm:ss'),'MMM-YYYY') as month

after derive the month field i want to create the line chart with rolling 12 months.if i have 4 months how to write the expression.

Thanks

[Kashyap_R]

Date(date#([Datecon.Dateeeeee],'DD/MM/YYYY hh:mm:ss'),'MMM-YYYY') as Month

[sunny_talwar]

May be this

Date(MonthStart(Date#(mydate, 'DD/MM/YYYY hh:mm:ss')), 'MMM-YYYY') as Month

or this

Date(MonthStart(mydate), 'MMM-YYYY') as Month

[StarinieriG]

Hi,

you could try with

date(floor(date#(mydate,'DD/MM/YYYY hh:mm:ss')),'MMM-YYYY') as month