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’)
bu...