For example if today is 19-06-2003 I want the result back: 15-06-2003(past sunday)
In Filemaker you can do this by setting a field:
Status(CurrentDate) - (DayofWeek(Status(CurrentDate)) -1)
Anyone can help me with this?
Status(CurrentDate) - (DayofWeek(Status(CurrentDate)) -1)
Q1: I want to get the full year of a date in field1
field1: date_input
field2: date_calc [calculation / stored / INT]:
Q2: The full year of today (in FMP: Year(Today))
What the first day of the week is depends on youre locale setting (see preferences and then locale tab)
If yours are dutch/NL then Monday is first day of week, if however it is set to USA then Sunday is first day of week.
Users browsing this forum: No registered users and 16 guests