Convert Date to Num in Automations

NiklasV — Wed, 05 Oct 2022 11:35:51 GMT

I need to have a numeric Date value to filter a report with, in Automations.
I'm able to create the first variable that holds a date using the "Date Formula", but I'm unable to convert it correctly into a numeric value with the second variable.
Tried using the "Convert Number Formula" but it returns 0.

Current Outcome:
Variable1: 2022-10-01 ->
Convert into Number ->
Variable2: 0

Expected Outcome:
Variable1: 2022-10-01 ->
Convert into Number ->
Variable2: 44839

Any ideas?

Re: Convert Date to Num in Automations

blaise — Wed, 05 Oct 2022 12:53:13 GMT

There ought to be better ways but you can convert the data to unix time, divide with 86400 (no of seconds in a day) and add 25569 (serial number of unix start time - 1970-01-01).

{add: {divide: {date: {$.vDate}, 'U'}, 86400}, 25569}

topic Convert Date to Num in Automations in Qlik Automate

Convert Date to Num in Automations

Re: Convert Date to Num in Automations