Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a dashboard and have today() function for comparing Order Date. I opened dashboard two days back and didn't close it but when I refreshed the dashboard still my today function is taking two days before date, not sure why it is happening like that.
Any suggestions.
Thanks,
hi
today() function return the that of last data load
for more details look at this
Are you using QV12?
UPDATE: Check if Today(1) makes any difference
Today() is having mode 0 by default which will show date at the time of script run
Today(1) will give date at function call
Today(2) will give date when the document was opened.
Then not sure what is the use of today function. then what should I use if I want to get the current date.
Thanks,
Like Manish pointed out, try Today(1)