• Registered: 2017-05-15
  • Posts: 722

Topic: SQLExecute

Hello MVD!

I want to count records which has a current date only.  Please help me about this issue using SQLexecute.

Thanks !
manixs

  • Registered: 2014-02-14
  • Posts: 10,294

Re: SQLExecute

Hello.


Check it out

SQLExecute( 'SELECT COUNT(id) FROM tablename WHERE date(datefield) = date(''now'')' );
Dmitry.
  • Registered: 2017-05-15
  • Posts: 722

Re: SQLExecute

YES. Thanks MVD!