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

Topic: Find record with Birthday with (datenow)

Hello MVD!

How to find a record having a birthday to the current date using SQLExecute?

pls help!

manixs

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

Re: Find record with Birthday with (datenow)

Hello WIZARDS!

How to find a record having a birthday to the current date using SQLExecute?

pls help! pls help!

manixs

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

Re: Find record with Birthday with (datenow)

Hello.


Check it:

SQLExecute( 'SELECT lastname FROM tablename WHERE strftime(''%d-%m'', birthdate) = strftime(''%d-%m'', ''now'')' );
Dmitry.
  • Registered: 2017-05-15
  • Posts: 722

Re: Find record with Birthday with (datenow)

YES AGAIN. THANKS A LOT!