Convert Date to Number

[qlikviewaf]

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]

Hi,

Try

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

[antoniotiman]

Hi Antonio,

it is already Dual Field (Text,Number)

Num(Invoice_Date_Num) -> 42766

Regards,

Antonio

[sunny_talwar]

Try this may be

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