hey, i am using the template of your pregancy calculator but i want to add the current pregancy week and i am facing two problems..
Fieldname1 (is day of last period)
fieldname11 the current date (GETDATETIMESTRING(NOW(), ‘dd/mm/yyyy hh:ii’);)
Then i have fieldname7 (output)
ROUND(ABS(fieldname1-fieldname11)/7) It kinda works but i would need always need to round down .. is there an option for this?
Or best Option would even be to show like current week + days but i am not sure how i could make an output like this.
Also i want to get ride of filedanme 11 and would like to use the current day in the calculation
but
ROUND(ABS(fieldname1-GETDATETIMESTRING(NOW(), ‘dd/mm/yyyy hh:ii’))/7 or ROUND(ABS(fieldname1-NOW())/7) is not working i am not sure how the date field are calculated or how is the best way to do math work with them .. maybe someone have an example how to work best with dates.