Convert time

[kkarlste]

Hi

How I can convert this dd-mm-yyyy to yyyymm?

[sunny_talwar]

May be like this

Date(MonthStart(Date#(DateField, 'DD-MM-YYYY')), 'YYYYMM') as YearMonth

[kkarlste]

Hi Thanks, but this not work.

PURCHASE DATE

30.09.2015

19.11.2015

30.11.2015

14.12.2015

This is a .CSV file and data is this mode

I change this DD-MM-YYYY to DD.MM.YYYY.

Have you any help?

[kkarlste]

Hi

Hi now it's working.

Thanks

[sunny_talwar]

Awesome.... If its working now, I would suggest you to close this thread by marking the correct response

Qlik Community Tip: Marking Replies as Correct or Helpful‌

Best,

Sunny