Date Validation Function?
Quote from PaulJonestindall on April 5, 2022, 11:26 amAnyone already have a quick date validation function in VB or JScript?
A basic one to check the format will do but if it checks not only the format but actual dates also that would be great.
I tried a number of RegEx examples online and every one came back with an error.Thanks.
Anyone already have a quick date validation function in VB or JScript?
A basic one to check the format will do but if it checks not only the format but actual dates also that would be great.
I tried a number of RegEx examples online and every one came back with an error.
Thanks.
Quote from Gaev on April 5, 2022, 3:22 pm@pauljonestindall
Take a look at this ... scripted Logic - neoHOW7
if it does not meet your needs, you can ...
- either modify it
- or post your exact requirements here
Take a look at this ... scripted Logic - neoHOW7
if it does not meet your needs, you can ...
- either modify it
- or post your exact requirements here
Quote from PaulJonestindall on April 5, 2022, 3:41 pm@gaev
Thanks. I'll give it a look.
Thanks. I'll give it a look.
Quote from Gaev on April 5, 2022, 7:56 pm@pauljonestindall
From your other post ...
I found that the postgresql database would not accept an invalid date.
In my text entry object I can type in an invalid date but when I use dbpSaveEdits, the field would not populate or if the field is already populated, it would not save the change. With no notification. So, I'd rather validate the date at the point of entry.Good practice no matter what the target DB.
Also, specifying content for date fields gets tricky (if i recall, you have to surround the date with ## characters).
From your other post ...
I found that the postgresql database would not accept an invalid date.
In my text entry object I can type in an invalid date but when I use dbpSaveEdits, the field would not populate or if the field is already populated, it would not save the change. With no notification. So, I'd rather validate the date at the point of entry.
Good practice no matter what the target DB.
Also, specifying content for date fields gets tricky (if i recall, you have to surround the date with ## characters).