I want to know what is the formula to identify that the document is expiry for example : document expiry is on 20-jun-2020 so once the current date is 20-jun-2020 in my report it should show expired I have attached my report kindly check and do the needful. i will share the code once it is finished.
Code: [Field:Note] Use : Name field Full Width: Yes Lines :2 Set as: IF $passportdate < $$machinedate then "Renewal" else if $passport = $$machinedate then "Expired" Storage: Notes Please check this code I want if $passport date is less than the machine date then it should show Renewal, and if the $passport date is more than or equal to passport date is should show expired
Got it !! thank you Amit Kamdar sir for always helping small developer and motivating us thanks a lot. i have completed this project shared the glimps.