edioguardi
Technical User
I have a main form which allows the user to enter and change parameters in queries which will populate tables in the database. For the majority of it's uses we use the same date range. When I try to set the default values dor the text box to these dates it returns a completely different date.
Example (from Properties)
StartDate- Default: 12/01/2000
Format: Short Date
End Date- Default: 11/30/2001
Format: Short Date
In Form View
Start Date returns:12/30/1899
End Date returns:12/30/1899
When I click in Start Date it switches to:12:08:38AM
When I click in End Date it switches to: 8:48:00 AM
Any Ideas?
Example (from Properties)
StartDate- Default: 12/01/2000
Format: Short Date
End Date- Default: 11/30/2001
Format: Short Date
In Form View
Start Date returns:12/30/1899
End Date returns:12/30/1899
When I click in Start Date it switches to:12:08:38AM
When I click in End Date it switches to: 8:48:00 AM
Any Ideas?