Today() returning yesterday - Timezone issue

[justinposcom]

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

[justinposcom]

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

[Almen]

Assuming you put the formular from earlier in a variable called vNow, try the following:

SUM({<[Transacted.autoCalendar.Date] = {"$(=$(vNow))"}>}TotalSalesExc)