topic Re: Convert Date to Number in QlikView

Convert Date to Number

qlikviewaf — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

i have this formula in my script:

DATE(MonthEnd(Date#(Month & '-' & Year,'MMM-YYYY'))) as Invoice_Date_Num

basically generate the last day of the month with an input of Month+Year.

I want to transform this date in data-format like 42766, how this can be done in Qlik? Thanks

ahaahaaha — Tue, 27 Jun 2017 14:52:58 GMT

Hi,

Try

Div(Num(DATE(MonthEnd(Date#(Month & '-' & Year,'MMM-YYYY')))), 1)

antoniotiman — Tue, 27 Jun 2017 14:53:43 GMT

Hi Antonio,

it is already Dual Field (Text,Number)

Num(Invoice_Date_Num) -> 42766

Regards,

Antonio

sunny_talwar — Tue, 27 Jun 2017 15:02:51 GMT

Try this may be

Floor(MonthEnd(Date#(Month & '-' & Year, 'MMM-YYYY'))) as Invoice_Date_Num