Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i have 2 feild with date, i want to calculte , the max date like this:
date = 03/01/2016
date1 = 28/12/2015
max_date=???
i want to show the max value beetwin 2 date feild but from feild "date" i need date-7
in the exm:
03/01/2016 - 7 =27/12/2015
so the maxdate feild need to show = 28/12/15
how to do it ?
thanks'
yarin.
In the script, you can try something like this:
Date(RangeMax((date -7), date1)) as maxDate