Skip to content

Instantly share code, notes, and snippets.

@expiscornovus
Created March 17, 2021 17:54
Show Gist options
  • Save expiscornovus/60f8f832009dae2174147f239b97375f to your computer and use it in GitHub Desktop.
Save expiscornovus/60f8f832009dae2174147f239b97375f to your computer and use it in GitHub Desktop.
First Tuesday of Month
if(equals(dayofWeek(startOfMonth(variables('Now'))), 2), startOfMonth(variables('Now')), if(equals(dayofWeek(startOfMonth(variables('Now'))), 1), addDays(startOfMonth(variables('Now')),1), if(equals(dayofWeek(startOfMonth(variables('Now'))), 0), addDays(startOfMonth(variables('Now')),2), addDays(startOfMonth(variables('Now')),sub(9,dayofWeek(startOfMonth(variables('Now'))))))))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment