jasonperl

Offsetting dayofweek

Discussion created by jasonperl on Nov 27, 2016
Latest reply on Nov 28, 2016 by okramis

I am trying to run a search for next week (Monday through Sunday) but since Filemaker starts the week on Sunday (day 1), I am having difficulty getting the results when running the script on Sundays. This is my calculation, but I am uncertain how to put in the offset. Any help would be awesome! Thanks.

 

( Get ( CurrentDate ) – DayOfWeek ( Get ( CurrentDate ) ) + 9 ) & “…” & ( Get ( CurrentDate ) + 15 – DayOfWeek ( Get ( CurrentDate ) ) )

Outcomes