Let ( Today = get ( curredate );
Today - dayOfWeek ( Today ) + 2
Brilliant logic (I think).
I will execute and let you know.
Director of Strategy & Design
Next Brand · Brand Strategy & Design
Unit 107, 3 Male Street, Brighton VIC 3186
T +61 3 9008 8988 · M +61 424 253 716
Next-Brand-Logo-Animated-2.gif 165.6 K
Do you need it on Sunday?
a revision to make your date field work:
Let ( myDate = <<myDateField>> // choose your field here
; myDate - DayOfWeek( myDate ) + 2
That's just for Monday!
You would change the "2" to the value you need (as in the function http://fmhelp.filemaker.com//help/15/fmp/en/#page/FMP_Help/dayofweek.html
) 1 represents Sunday, 2 represents Monday, 3 represents Tuesday, and so on...
p.s. you can find several custom functions for dates:
This simple formula will return the date of a given day for the week (Sunday - Saturday) from date input.
Test Date + ( Week Day Wanted - DayOfWeek(Test Date)) /* Week Day Wanted is 1-7 */
Test Date + ( 2 - DayOfWeek(Get(Test Date))) /* hard coded for Monday */
/* Will give Monday's date from any date of the week. */