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
My Visual Database → General → 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
Hello WIZARDS!
How to find a record having a birthday to the current date using SQLExecute?
pls help! pls help!
manixs
Hello.
Check it:
SQLExecute( 'SELECT lastname FROM tablename WHERE strftime(''%d-%m'', birthdate) = strftime(''%d-%m'', ''now'')' );
YES AGAIN. THANKS A LOT!
My Visual Database → General → Find record with Birthday with (datenow)
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi