How I can convert this dd-mm-yyyy to yyyymm?
May be like this
Date(MonthStart(Date#(DateField, 'DD-MM-YYYY')), 'YYYYMM') as YearMonth
Hi Thanks, but this not work.
This is a .CSV file and data is this mode
I change this DD-MM-YYYY to DD.MM.YYYY.
Have you any help?
Hi now it's working.
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
Retrieving data ...