anyone know how to covert a date to unix timestamp...
# general
f
anyone know how to covert a date to unix timestamp in a saved search?
s
Something close to this would be my guess
Copy code
to_date({your date}, 'MM/DD/YYYY HH24:MI:SS') - to_date('19700101', 'YYYYMMDD')) * 24 * 60 * 60 * 1000
k
I had to do this today, parking for reference. This worked for the conversion on record changes:
({systemnotes.date}-TO_DATE('19700101','YYYYMMDD'))*86400
in a
Formula (Numeric)
field.