Formula in querry

[Simon4]

dear all,

How do i apply this formula in my querry, i tried this but it is not working:

tbl_bookingdate:
LOAD
*,
if( date(DATECONFIRMED) < firstsortedvalue(date(date_paid), date(INVOICEDATE)), date(DATECONFIRMED),
firstsortedvalue(date(date_paid), date(INVOICEDATE))) as Date_booked;

thanks in advance.

Kind regards,

Simon

[BrunPierre]

Would you like to share some data and expected results?

[Simon4 · Accepted solution]

I already fixed the issue.