Custom Field Help: Comparing Dates

Hello.

I don’t fully understand your message. You mention a “custom field”, is that on an IFS data table or on a custom page? 

From what I understand, if you want to make that kind of custom field, you would need to create a read*only type, and you would need to define parameters, but I can’t know which ones you need in your case… And your custom field needs to return a text.

It would be better to use a SELECT CASE in your case, so it would be like this :

SELECT CASE WHEN CF$_rental_start_date = CF$_on_demand_date THEN ‘pass’

when CF$_rental_start_date-1/24 = CF$_on_demand_date THEN ‘pass’

ELSE ‘fail’

END

FROM XXXXXXX

WHERE XXXXX

Hello @lisa.gilesAB 

I don’t use expressions in my case but only SELECT.

“Rental Start Date is a Custom Field within the LU”, I understand you are talking about a custom LU, therefore, a custom page. Every custom field in a custom LU / page starts with “CF$_” in their name, if you can use SQL Developer, you can easily notice that.

In the arguments field, you can type t.cf$_ALLOCATED_SERIAL 

In your SQL Query, you need to replace

WHERE ALLOCATED_SERIAL = :ALLOCATED_SERIAL

by

WHERE CF$_ALLOCATED_SERIAL = :cf$_ALLOCATED_SERIAL