Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm using the today() function but for the first half of the day it is retuning yesterdays date. Could it be a timezone issue? Is there a way to change to GMT+10 so today returns todays date from 12.00am each day
Thanks for your help
Adding the Variable is a great idea but are you able to help me format it to replace Today() in this expression
SUM({<[Transacted.autoCalendar.Date] = {'$(=Today())'}>}TotalSalesExc)
I keep getting no results
Assuming you put the formular from earlier in a variable called vNow, try the following:
SUM({<[Transacted.autoCalendar.Date] = {"$(=$(vNow))"}>}TotalSalesExc)