Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @ajaysingh121

    The equation would be simple:

    GETDATETIMESTRING(DATETIMESUM('03/03/2023', 'dd/mm/yyyy', 60, 'd'), 'dd/mm/yyyy')

    Best regards.

    Thread Starter ajaysingh121

    (@ajaysingh121)

    Thank you for your reply

    i want to result in: Friday, September 29, 2023 this formate

    Plugin Author codepeople

    (@codepeople)

    Hello @ajaysingh121

    In this case, you must use different operations to get the corresponding date components:

    
    (function(){
    var d = DATETIMESUM('03/03/2023', 'dd/mm/yyyy', 60, 'd');
    
    return CONCATENATE(WEEKDAYNAME(d), ', ', MONTHNAME(d), ' ', DAY(d), ', ', YEAR(d));
    })()

    Best regards.

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

The topic ‘date calculator’ is closed to new replies.