Date format issues in Qliksense

[niha]

Hello,

In a Particular report the data format was like 04/22/2017 . To get the correct requirement I did the following codes and all worked fine. I had to convert the date format to Year, Month, YearMonth(numeric.)

[Paid Amount],
Date( [Paid Year Month]) as [ Date Paid],
Year([Paid Year Month]) as DPYear,
Month([Paid Year Month]) as DPMonth,
Day([Paid Year Month]) as DPDay,
Year([Paid Year Month])& (Month([Paid Year Month])) as DPYearMonth,
Year([Paid Year Month])&NUM(Month([Paid Year Month]),'00') as DPYearMonthnum,

but in backed the format changed like  2017-04.  ALL my date field is blank and visualization is not working. Please suggest.

Regards,

Niha

[dplr-rn]

What is the data in the source column [Paid Year Month]

[niha]

the format is now: 2017-04 . 

YYYY-MM

[niha]

PAID -YEAR-MONTH is just a date that is coming in YYYY-MM format. Say 2017-04, 2017-05, 2017-06, 2017-07 etc.

I need to convert Year, Month, YearMonth. My out put should be 201701, 201702, 201703 like this from above format.

Thanks,

Niha

[Anvesh]

Hi Neha,

Try this

Date(PAID -YEAR-MONTH,'YYYYMM') as New_Date.

Thanks

Anvesh

[niha · Accepted solution]

Hello,

That did not worked but this worked. Thanks .

Date(Date#([Paid Year Month], 'YYYY-MM'), 'YYYYMM') as [Date Paid],

https://community.qlik.com/t5/Qlik-Sense-Enterprise-Documents/Dealing-with-date-formats-in-QlikView-...