Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
awalhashim
Contributor II
Contributor II

Multiple IF statements expression

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

3 Replies
dplr-rn
Partner - Master III
Partner - Master III

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')

Anonymous
Not applicable

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?

Anil_Babu_Samineni

What if conditions and what output you are expecting in the parameters?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful