Janet

And thank you for your patience!!!
Have a great weekend.
jh

Dear Codepeople,

All is now working….here are my codes

For Column One
GETDATETIMESTRING(DATETIMESUM(fieldname39, ‘mm-dd-yyyy’, (-24), ‘m’, true), ‘mm-dd-yyyy’)

For Column Two
DATEDIFF(fieldname38, fieldname20, ‘mm-dd-yyyy’, ‘d’)[‘days’];

And since a picture is a 1000 words, here is an image of my autofill form.
https://ibb.co/N7NdWj2

Thank you so much. I wouldn’t have been able to resolve without your help.
jh

It Works!

Here are my notes for future look up if I need to repeat:

Code 01: To Calculate 24 Months Before Renewal Date: (Use Months Instead of Days) **Code Successful***
GETDATETIMESTRING(DATETIMESUM(fieldname39, ‘mm-dd-yyyy’, (-24), ‘m’, true), ‘mm-dd-yyyy’)

Code 02: Last Treatment: Countdown **Code Successful**
DATEDIFF(fieldname38, fieldname20, ‘mm-dd-yyyy’, ‘d’)[‘days’];

where fieldname39=any future date greater than 24 months from today
where fieldname38=today’s date expressed as blank
where fieldname20=code 01

Thank you so much for your patience. You did an excellent job!!

Dear Codepeople

Thanks so much for your video. ?? I really appreciate your efforts !!

In my own attempt to fix this function, I opted to change from the function from days to months to read as follows:

GETDATETIMESTRING(DATETIMESUM(fieldname39, ‘mm-dd-yyyy’, (-24), ‘m’, true), ‘mm-dd-yyyy’)

And this latest reiteration seems to work much better regardless the number of the months subtracted from the future date (fieldname39).

The end goal is enter one date value, once, into the (fieldname39) and have the CFF form automatically update the calendar values for the whole form. With this first automation piece of the function puzzle now resolved, is it possible to use another fieldname to complete countdown days left each time this code is repeated but with a different month variable?

Eg:
GETDATETIMESTRING(DATETIMESUM(fieldname39, ‘mm-dd-yyyy’, (-24), ‘m’, true), ‘mm-dd-yyyy’)
Get Countdown days from 24 months of fieldname39?

GETDATETIMESTRING(DATETIMESUM(fieldname39, ‘mm-dd-yyyy’, (-12), ‘m’, true), ‘mm-dd-yyyy’)
Get Countdown days from 12 months of fieldname39?

GETDATETIMESTRING(DATETIMESUM(fieldname39, ‘mm-dd-yyyy’, (-5), ‘m’, true), ‘mm-dd-yyyy’)
Get Countdown days from 5 months of fieldname39?

Of course, I know the code for countdown would need its own field placeholder for each (24,12,5 mths)to delivery the three countdown outputs.

Or is the GETDATETIMESTRING(DATETIMESUM(fieldname39, ‘mm-dd-yyyy’, (-5), ‘m’, true), ‘mm-dd-yyyy’) now too complicated to create a countdown days code?

In my own attempt for countdown, I used this code (below) but it did not work.

PREC(abs(fieldname39-fieldname36),0)

In advance, I thank you for all your help so far.

Best Regards
jh

Dear Codepeople,

Simply WOW! Thanks so much for the quick video. ?? Please allow me a little time to review your video and I will get back to you.

Many Kind Thanks
jh

Dear Codepeople

Thank you so much for your quick reply. Had to reorder date format to read this:

GETDATETIMESTRING(DATETIMESUM(fieldname39, ‘mm-dd-yyyy’, (-730), ‘d’, true), ‘mm-dd-yyyy’)

What I have experienced from this code is that (-730) does not compute. So I played around and any value 10 and under, eg: (-10) and the code does work….so I am wondering if there is a code limit or a format issue for higher value numbers placed between the brackets?

Hello,

How may I share my link privately?
Many thanks,
wp enthusiast

Thank you so much. Is there a way to keep the URL private?

Thanks again.
WP Enthusiast

Thank you once again for your very quick reply.
Best

Thank you so much for your super quick reply.
I will follow your recommendations.
Many thanks,
Janet

Hello,

This “expired session” applies to my wp site too. The expired session a closed loop experience where one cannot seem to open elementor plugin Here’s the message:

“Loading
Close dialog
Session expired

Please log in again. The login page will open in a new window. After logging in you can close it and return to this page.”

Hope this can be fixed as I would love to try out elementor. Many thanks.

Hello,

Re: Avada Theme

The exact same thing happened to me in the last 12 hours. I am able to add the element from the “Element Builder” to my Avada theme page.

However, when I attempt to launch the actual element itself, my whole screen greys out. At first I thought it may be my computer. Now I know I am not alone. It must be the theme. I will reach out to the developers to see what’s up.

Many thanks.
Janet