jnhoward21

Found it. Thanks for your help.

Thank you! That worked great. One more question. Is there a way to exclude weekends using this same operation?

(function(){
var d = DATETIMESUM(TODAY(), 'yyyy-mm-dd', fieldname1, 'd');
return WEEKDAYNAME(d)+' '+MONTHNAME(d)+' '+DAY(d)+' '+YEAR(d);
})()

@codepeople

No Worries! That worked! Once more question. is there a way to format the output for it to view in this format?

Monday August 8 2023

Currently it outputs yyyy-mm-dd, which is fine, but wanted to see if there is another output option. Thanks!

Hello @codepeople

Thank you for the quick response. I tried the getdatetimestring operation, and returns a blank field.

How can I remove the time and timezone stamp from a calculated field? I need to sum 2 dates and output the date only in the calculated field. Here is the calculated field I am using.

DATETIMESUM(‘today()’, ‘yyyy-mm-dd’, fieldname1, ‘d’)

But it continues to return this format.

Tue Aug 08 2023 09:54:24 GMT-0400 (Eastern Daylight Time)

How can the time and time zone be removed from the output.

Thank you.