Date Calculation based on today

msreyes 24 Jun, 2020
I am doing a database read to get the date from this field. I need to do an if statement to check where it sits based on "today"... what am I doing wrong... tried with and without the curly brackets, etc??

Date Calculation based on today image 1
Max_admin 24 Jun, 2020
that will not work, you will need to format the data as a timestamp, like this:
{date:U$(var:read_data...)}
same for the other var, which is wrong, what are you trying to get with {$currentdate} ?
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
msreyes 24 Jun, 2020
The {$currentdate} was trying to read today's date.

In my scenario I have a date in the database. If it is before today's date do one thing, if it's after today's date do another.
It's going to be a piece of equiement with an expiration date.
Max_admin 24 Jun, 2020
so compare {date:U} and {date:U$(var:read_data.....)}
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.

VPS & Email Hosting 20% discount
hostinger