I am trying to create a custom field but I have having an issue getting it to work.
I have 2 Dates:
- On Demand Date
- Rental Start Date (Custom Field)
I want to create a Custom Field that does the following and I am not sure if it is possible:
If
rental_start_date = on_demand_date then ‘Pass’
else
if
rental_start_date-1/24 = on_demand_date then ‘pass’
else ‘fail’
Both fields exist in the same LU but I keep getting a bind error and I cannot work out what the correct syntax should be.
I think I need a Select Case When () but I cannot seem to get it correct.
Thanks in advancec