we use in Filemaker:
Date(Month;1;Year) - DayofWeek(Date(Month;1;Year)) + 1
BTW: Month and Year are in Filemaker, number fields.
Does anyone know how to convert this in Servoy?
we use in Filemaker:
Date(Month;1;Year) - DayofWeek(Date(Month;1;Year)) + 1
BTW: Month and Year are in Filemaker, number fields.
Does anyone know how to convert this in Servoy?
Date(Month;1;Year) - DayofWeek(Date(Month;1;Year)) + 1
I would say (where d as type date):
var dd = new Date(d.getYear, d.getMonth, d.getDate - d.getDay + 1)
where getDate = day of Month and getDay = day of Week (0 = sunday)…
Not completly, but I could (with help from your example) make the right one
var a = new Date(year1, month1, 1)
var b = a.getDay + 1
datecalc = a.setDate(a.getDate()- b)
Thanks.