Skip to Content Skip to Menu

[SOLVED] current Date Query

  • webaholic
  • webaholic
  • OFFLINE
  • Posts: 17
  • Thanks: 2
  • Karma: 0
6 years 11 months ago - 6 years 10 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.
Last edit: 6 years 10 months ago by krileon. Reason: Added [SOLVED] tag to subject

Please Log in or Create an account to join the conversation.

  • webaholic
  • webaholic
  • OFFLINE
  • Posts: 17
  • Thanks: 2
  • Karma: 0
6 years 11 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 or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum