max date with 2 feilds

Anonymous — Sun, 27 Dec 2015 06:24:02 GMT

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.

Re: max date with 2 feilds

sunny_talwar — Sun, 27 Dec 2015 06:35:34 GMT

‌In the script, you can try something like this:

Date(RangeMax((date -7), date1)) as maxDate