Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Combining Concatenate Week Of with timezone

Topic Labels: Dates & Timezones
185 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello,

I’m trying to combine this formula:

CONCATENATE(“Week of Mon”," ",DATETIME_FORMAT(DATEADD({Job Date},-DATETIME_FORMAT({Job Date},‘e’)+1,‘days’),‘M/D’))

With this one:

DATETIME_FORMAT(SET_TIMEZONE({Job Date},‘America/Chicago’), ‘DD/MM/YYYY’)

but I can’t get the syntax right. I need the timezone stipulation because when a {Job Date} is a Sunday, the Week Of formula is grouping it one week ahead (so, job date of Sunday 3/27 is getting grouped with Week of Monday 3/28 instead of Week of Monday 3/21).

Thanks in advance for any help!

1 Reply 1

P.S. I do have all of my curly quotes converted to straight. Thanks!