Expiry date calculation

  • Resolved shameerkr

    (@shameerkr)


    3 years, 2 months ago

    Hi,

    I just want to generate expiry date of a product from dropdown box.

    eg.

    Item name (dropdrown with search) – Item1 (Expiry 30 Days)

    Prod Date – date field (24/03/2023)

    Expiry – 23/04/2023

    Thanks,

    • This topic was modified 3 years, 2 months ago by shameerkr.
Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter shameerkr

    (@shameerkr)

    3 years, 2 months ago

    Below code is working fine. The result getting as 8, April 2023, but i need 08/04/2023 format.

    (function(){
    var d = fieldname11+fieldname12;

    return DAY(d)+’, ‘+MONTHNAME(d)+’ ‘+YEAR(d);
    })()

    Thread Starter shameerkr

    (@shameerkr)

    3 years, 2 months ago

    Now its OK.

    (function(){
    var d = fieldname11+fieldname12;

    return DAY(d)+’/ ‘+MONTH(d)+’/ ‘+YEAR(d);
    })()

    Plugin Author codepeople

    (@codepeople)

    3 years, 2 months ago

    Hello @shameerkr

    Excellent !!!

    Another alternative would be:

    GETDATETIMESTRING(fieldname11+fieldname12, 'dd/mm/yyyy')

    Best regards.

    Thread Starter shameerkr

    (@shameerkr)

    3 years, 2 months ago

    Wow great. Thanks

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Expiry date calculation’ is closed to new replies.