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.
Last edit: 7 years 1 month ago by krileon. Reason: Added [SOLVED] tag to subject