Calculate the numeric differential between two date fields and display in in a third field
I have now spent two weeks on attempting to accomplish this with varying scripts found here -- to include mixing and matching -- to no avail. Theoretically, it seems simple enough but is clearly beyond my level of understanding or capability. I am technically attempting to achieve two different outcomes and to my untrained eye they appear as if they would be similar, yet both lead me to a highball of bourbon at the end of my day. 😉
I have a form with multiple date fields -- some are essentially paired (i.e. "start_date" and "end_date) and another is stand-alone (i.e. "fixed_date").
For the paired, I am attempting to calculate the differntial into either a negative or positive digit with the resulting number of days displaying in a third field in either red (negative) or black (positive).
For the single, I am attempting to have a date displayed in one of three colors based on the required periodicity of a qualification. Some quals expire after one year so I'm trying to display the date in either black (greater than 30 days to expiration), yellow (within 30 days of expiration), and red (qualification expired).
My sincerest thank in advance for any and all assistance.
Very Respectfully,
Charlie
