Quote from joferar333 on January 15, 2025, 1:10 am@vadim, @gaev, @emo
SPANISH
tengo un problema que no logro dar con la solucion y seguro que debe ser una tontera, he probado de todas las formas posible pero no logro el objetivo.
Agradeceria que vieran este video donde describo paso a paso el problema
1 - Creo una base de datos
2 - creo una tabla
3 - creo dos campos dentro de la tabla 1 tipo date (fecha) y el otro string (texto)ingreso registros....
el problema esta cuando quiero filtrar y mostrar solo los registros de un rango de fechas, desde una fecha inicio a una final... ahi esta y radica mi problema
adjunto al pub y la base
Ojala me puedan dar una mano ya que me estoy volviendo loco...VER EL VIDEO (VIDEO AUDIO Y SUBTITULOS EN INGLES)
https://globaldima.com/basedato.mp4ENGLISH
I have a problem that I can't find the solution to and I'm sure it must be a nonsense, I've tried all possible ways but I can't achieve the objective.
I would appreciate it if you could watch this video where I describe the problem step by step
1 - I create a database
2 - I create a table
3 - I create two fields within the table 1 type date (date) and the other string (text)I enter records...
The problem is when I want to filter and show only the records of a date range, from a start date to a final date... that's where my problem lies
attached to the pub and the databaseI hope you can give me a hand because I'm going crazy...
WATCH THE VIDEO (VIDEO AND AUDIO IN INGLISH)
https://globaldima.com/basedato.mp4
best Regards
SPANISH
tengo un problema que no logro dar con la solucion y seguro que debe ser una tontera, he probado de todas las formas posible pero no logro el objetivo.
Agradeceria que vieran este video donde describo paso a paso el problema
1 - Creo una base de datos
2 - creo una tabla
3 - creo dos campos dentro de la tabla 1 tipo date (fecha) y el otro string (texto)
ingreso registros....
el problema esta cuando quiero filtrar y mostrar solo los registros de un rango de fechas, desde una fecha inicio a una final... ahi esta y radica mi problema
adjunto al pub y la base
Ojala me puedan dar una mano ya que me estoy volviendo loco...
VER EL VIDEO (VIDEO AUDIO Y SUBTITULOS EN INGLES)
https://globaldima.com/basedato.mp4
ENGLISH
I have a problem that I can't find the solution to and I'm sure it must be a nonsense, I've tried all possible ways but I can't achieve the objective.
I would appreciate it if you could watch this video where I describe the problem step by step
1 - I create a database
2 - I create a table
3 - I create two fields within the table 1 type date (date) and the other string (text)
I enter records...
The problem is when I want to filter and show only the records of a date range, from a start date to a final date... that's where my problem lies
attached to the pub and the database
I hope you can give me a hand because I'm going crazy...
WATCH THE VIDEO (VIDEO AND AUDIO IN INGLISH)
https://globaldima.com/basedato.mp4
best Regards
Uploaded files:
Quote from Gaev on January 15, 2025, 2:35 am@joferar333
It looks like prueba.pub is just an empty page; where is the code you showed attached to buttons in your video ?
I think I know what your problem is ... Access Database only handles dates in American Date Format; in the video, you appeared to be specifying date ranges in dd/mm/ccyy format ... I will be able to confirm after you share your pub with your dbpXXXX and dbpExecSql commands
It looks like prueba.pub is just an empty page; where is the code you showed attached to buttons in your video ?
I think I know what your problem is ... Access Database only handles dates in American Date Format; in the video, you appeared to be specifying date ranges in dd/mm/ccyy format ... I will be able to confirm after you share your pub with your dbpXXXX and dbpExecSql commands
Quote from joferar333 on January 15, 2025, 4:33 am@gaev
Sorry, you're right, I posted the wrong post. I'll send it to you here. Please, I've already tried changing the date format. See if you can adjust it so the example works. Thank you so much, this is driving me crazy.
Best Regards
Sorry, you're right, I posted the wrong post. I'll send it to you here. Please, I've already tried changing the date format. See if you can adjust it so the example works. Thank you so much, this is driving me crazy.
Best Regards
Uploaded files:Quote from Gaev on January 15, 2025, 6:44 pm@joferar333
As I said before, the problem is the date format you are using.
You will need to recreate the database with an additional field (say internal_fecha) that is either numeric or string of length 10; this field should contain values like 20250109 (numeric) or 2025/01/09 (string); then do the search/filter on this internal_fecha field.
You will then have to automatically update this field (from fecha) every time fecha is changed.
Let me know if this workaround is acceptable to you, and I will make a working sample when I get some spare time.
As I said before, the problem is the date format you are using.
You will need to recreate the database with an additional field (say internal_fecha) that is either numeric or string of length 10; this field should contain values like 20250109 (numeric) or 2025/01/09 (string); then do the search/filter on this internal_fecha field.
You will then have to automatically update this field (from fecha) every time fecha is changed.
Let me know if this workaround is acceptable to you, and I will make a working sample when I get some spare time.
Quote from joferar333 on January 15, 2025, 7:09 pm@gaev
Yes, my friend, I'm waiting for your example. Whatever it takes, as long as it works for me. I have no problem waiting. Thank you very much. With your example, I can adapt it for the current project.
best regards
Yes, my friend, I'm waiting for your example. Whatever it takes, as long as it works for me. I have no problem waiting. Thank you very much. With your example, I can adapt it for the current project.
best regards
Quote from Gaev on January 17, 2025, 4:04 am@joferar333
Here is a pub that illustrates a workaround for the limitation of the Access database regarding Date Formats.
Note that this pub focuses on illustrating the technique and diagnosis/learning experience (so AlertBox and Grid Column can be hidden away).
It also is incomplete in that it does not attempt to catch all user errors (like clicking multiple times on the Start Button or checking that From Filter Date is less than or equal to To Filter Date.
Here is a pub that illustrates a workaround for the limitation of the Access database regarding Date Formats.
Note that this pub focuses on illustrating the technique and diagnosis/learning experience (so AlertBox and Grid Column can be hidden away).
It also is incomplete in that it does not attempt to catch all user errors (like clicking multiple times on the Start Button or checking that From Filter Date is less than or equal to To Filter Date.
Uploaded files:Quote from joferar333 on January 18, 2025, 12:01 pm@gaev
Dear friend, thank you very much for your time. I find it very interesting and I am sending you an example that a colleague sent me, where he apparently found the solution to the limitation of the date format, since the example uses the local date, that is, here in Argentina it is d/mm/yyyy. I have tested it and it works perfectly, it filters the dates between the initial and final dates, that is why I am sending it to you. I think it is interesting to take this alternative into account. For me it was the great solution. Best regards and once again a thousand thanks.
Dear friend, thank you very much for your time. I find it very interesting and I am sending you an example that a colleague sent me, where he apparently found the solution to the limitation of the date format, since the example uses the local date, that is, here in Argentina it is d/mm/yyyy. I have tested it and it works perfectly, it filters the dates between the initial and final dates, that is why I am sending it to you. I think it is interesting to take this alternative into account. For me it was the great solution. Best regards and once again a thousand thanks.
Uploaded files: