is there any way I get timestamp in saved search o...
# suiteanalytics
s
is there any way I get timestamp in saved search of date?
g
For the current date?
you could add a results row as Formula (Date) and in the formula for that row simply put {today}
s
I want something like millisecond from 1970
i
Create a Formula(Numeric) field and paste this formula: (sysdate - to_date('19700101', 'YYYYMMDD')) * 24 * 60 * 60 * 1000
you could also use {today} instead of sysdate - it works out the same
s
@iann Thanks its work.
m
I think
sysdate
might be the server timezone and
{today}
the local user timezone
👍 1