Forum Discussion

some_analyst's avatar
some_analyst
Icon for Helper I rankHelper I
1 year ago
Solved

Changing when 'Today' starts on the server

I have a slicer which shows me the date: Formatted Date Full = VAR SelectedDate = dim_date[PK_date] RETURN IF( SelectedDate = TODAY(), "Today", CONCATENATE( CONCATENATE(dim_dat...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    Hi some_analyst 

     

    Use UTCNOW() instead of TODAY() to reflect the current UTC time. Note that UTCTODAY() always returns the UTC datetime at 12:00 AM, regardless of the actual time of day in UTC.  Also, you can simply the date format to just  FORMAT(SelectedDate, "dddd, dd/mm/yyyy") instead of using CONCATENATE.

AndrewPNZ's avatar
AndrewPNZ
Icon for Advocate I rankAdvocate I
1 year ago

This may be of help; to get the current date/time in New Zealand, in the past I have used a dataflow with a single table that just gets the current date-time UTC offset for New Zealand from a public timezone API, extracts the hour offset, converts the JSON result to table, and extracts the currentUtcOffset and then divides the seconds from this by  3600 to get hours (12 at the moment), and add that to UTCNOW(). 

 

https://timeapi.io/api/timezone/zone?timeZone=Pacific%2FAuckland

A bit of overhead to refresh this daily but it works. The specific API used above is just an example, but does look suitable.