jnhoward21
Forum Replies Created
-
Forum: Plugins
In reply to: [Calculated Fields Form] Date CalculatorFound it. Thanks for your help.
Forum: Plugins
In reply to: [Calculated Fields Form] Date CalculatorThank 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); })()Forum: Plugins
In reply to: [Calculated Fields Form] Date CalculatorNo 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!
Forum: Plugins
In reply to: [Calculated Fields Form] Date CalculatorHello @codepeople
Thank you for the quick response. I tried the getdatetimestring operation, and returns a blank field.
Forum: Plugins
In reply to: [Calculated Fields Form] Date CalculatorHow 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.