SQL / Date Question
Status: Closed · Asked by JoeyTroy on · 0 views
I have the SQL working and connecting and wondering if we can write SQL entries to the table? I have two fields one is Member Since and one is Member Expire. Since the member is signing up would be today and expiration would be in 365 days I tried to write a SQL statement into the box
Sadly it wrote straight text to the database and did not put the date and the date + 365 days.
Hey @JoeyTroy
If you want to pass the date in the fields according to your calculation then, please check the "DateTime Formatter" action step.
Supreme, I was able to do it by making two more requests to MySQL database for queries and was able to solve that but this looks easier so I will go back and fix that.