Hello @ajaysingh121
The equation would be simple:
GETDATETIMESTRING(DATETIMESUM('03/03/2023', 'dd/mm/yyyy', 60, 'd'), 'dd/mm/yyyy')
Best regards.
Thank you for your reply
i want to result in: Friday, September 29, 2023 this formate
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.
