SQL / Date Question

[JoeyTroy]

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.

 

[Pabblymember11]

Hey @JoeyTroy

If you want to pass the date in the fields according to your calculation then, please check the "DateTime Formatter" action step.

 

[JoeyTroy]

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.