[SOLVED] current Date Query

6 years 5 months ago - 6 years 4 months ago #299252 by webaholic
[SOLVED] current Date Query was created by webaholic
Hello,

I would like to use the value "date system" in a query (CB Auto Actions), it is a condition in a query of type
Update table SET value = 1 Where "date of today"> = [fields date1] ;
as a trigger (onafterUserUpdate, onafterUserSaveRegistration).
I tried several formulas: CURRENT_DATE (); ((CONVERT (date, SYSDATETIME ()) ..but it does not work,
would you please have an example of cb autoactions/ query ( i already watch the vidéos tutos.) ?

thx.
so.

Please Log in to join the conversation.

6 years 5 months ago #299253 by webaholic
Replied by webaholic on topic current Date Query
sorry, I just found the solution by myself :)
this is the function: NOW ().

I leave the post in case someone else needs it

@+
The following user(s) said Thank You: krileon

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.165 seconds

Facebook Twitter LinkedIn