Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys, need some help here with if statement logics.
i have 2 date fields
1. createdDate
2. BookingDate
conditions
1. createdDate should be lesser than BookingDate
2. createdDate to BookingDate range must not be more than 1 year.
How do i achieve this? need help cause am newbie here
Not sure i understand any deeper complexity but taking your post at face value
if(BookingDate-createdDate>365,'More than a year','Less than a year')
Are you trying to achieve this in the layout or the Datamodel?
i.e. Are you trying to restrict the data in the load itself or in the chart?
What if conditions and what output you are expecting in the parameters?