Need help for report customization

Discussion in 'Requests' started by vinayprasad.Dubai, Jun 12, 2020.

    

  1. 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.

    [​IMG]
     

    Attached Files:




  2. 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
     


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Set as: IF $passportdate < $$machinedate then "Renewal" else "Expired"
     



  4. 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.
     

    Attached Files:



Share This Page