max date with 2 feilds

[Anonymous]

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.

[sunny_talwar]

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

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