| | |
How to check a valid date...
Thread Solved |
•
•
Join Date: Jun 2009
Posts: 5
Reputation:
Solved Threads: 0
Hi everyone!
I have a problem related with dates.... i have some textbox where i put dates to send to a database... i have conditioned the input just for numbers and / (backslash), but how do i check that no one inserts a format that's not dd/mm/yyyy... if i put 1234 sends an error and stops
Thanks everyone!
I have a problem related with dates.... i have some textbox where i put dates to send to a database... i have conditioned the input just for numbers and / (backslash), but how do i check that no one inserts a format that's not dd/mm/yyyy... if i put 1234 sends an error and stops
Thanks everyone!
You have to parse each field and check to see if its legitimate.
Also check the day number to number of days in that month.
And double check if its a leap year or not.
You could parse and convert to Julian and store as a 32-bit number.
You may want to consider allowing dwarf entries so that for example today is 6/29/2009 but if someone enter 7/11 it will exchange 7/11 for 7/11/2009 automatically or with a verify! It gets very old having to enter a complete date every time!
You may consider a date split - six months vs + six months so that for example entry of past invoices allows a dwarf date!
Also check the day number to number of days in that month.
And double check if its a leap year or not.
You could parse and convert to Julian and store as a 32-bit number.
You may want to consider allowing dwarf entries so that for example today is 6/29/2009 but if someone enter 7/11 it will exchange 7/11 for 7/11/2009 automatically or with a verify! It gets very old having to enter a complete date every time!
You may consider a date split - six months vs + six months so that for example entry of past invoices allows a dwarf date!
![]() |
Similar Threads
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: AutoClicker
- Next Thread: Have a question....
| Thread Tools | Search this Thread |
* 6 429 2007 access activex add age application basic beginner birth bmp calculator cd cells.find click client code college component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report save search sendbyte sites sort sql sql2008 sqlserver subroutine tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows





