Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I already fixed the issue.
Would you like to share some data and expected results?
I already fixed the issue.