Hi All
I have a simple table Reservas, with several fields. One of them is Date, (type date of course)
When I try to run a simple query filter on it
Always return "No matches found!". Doesn't matter if I use quotes or not around the date ('2023-05-12'), or the order DD-MM-YYYY
Howewer, when I run the followin query on MySQL console
SELECT * FROM `reservas` WHERE `Date` = '2023-05-12'
the result is, as expected:
What I'm doing wrong? How can I filter on dates?
Regards!
How can I filter dates?
Re: How can I filter dates?
When filtering a date data type field - I think you'll find it depends on what date format you originally selected to store date fields in your Appgini project.
Let's say you select DD/MM/YYYY for date formats in your Appgini project
"date" type fields are of course still recorded in the database as YYYY-MM-DD
But to filter one of those date fields in the app, use the format originally chosen in the Appgini project - DD/MM/YYYY
Works for me - hopefully it will work for you too
Let's say you select DD/MM/YYYY for date formats in your Appgini project
"date" type fields are of course still recorded in the database as YYYY-MM-DD
But to filter one of those date fields in the app, use the format originally chosen in the Appgini project - DD/MM/YYYY
Works for me - hopefully it will work for you too
Re: How can I filter dates?
Hi,
I would also thin, you will need to enter the date as it is displayed in your table view.
Olaf
I would also thin, you will need to enter the date as it is displayed in your table view.
Olaf
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
Re: How can I filter dates?
Hi
Thansk for your help!. Yes, you are right. The orginal format in Appgini was 'DD/MM/YYYY'
So, the filter must be like 15/05/2023. The trick was the slash! (/)
Thanks again!
Thansk for your help!. Yes, you are right. The orginal format in Appgini was 'DD/MM/YYYY'
So, the filter must be like 15/05/2023. The trick was the slash! (/)
Thanks again!
Re: How can I filter dates?
Hi,
do you know: You can change how the dates are displayed in AG
Olaf
do you know: You can change how the dates are displayed in AG
Olaf
Some postings I was involved, you might find useful:
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view
SingleEdit - Prevent concurrent edits on records; Field Permissions; Column-Value-Based-Permissions; Custom (error) message; Audit Log; Backup your database; Two Factor Authentication; Block brute force (failed) logins; Add 2nd SAVE CHANGES button; Place a search on details view