I want to make an If condition comparing a date in dateTime format from a table of MainData with SessionDate (dateTime format) of GeneralData . How can I do it?
my report is the purchase agreement and i want to see only rows that have expirationDate < sessionDate (or now() ).
can you help me do it?
I did in the if condition: AgreementLineTmp/@ExpirationDate >= GeneralData/Misc/@SessionDate but it not works.