default value for dates [message #185709] |
Thu, 03 August 2006 03:49 |
cong
Messages: 25 Registered: June 2006
|
Junior Member |
|
|
i have parameters start date and end date. if the user doesn't enter any value, default value for end date is null. with start date, is the most logical thing to do is to get the earliest date from the database? i'm querying from 3 big tables, this might slow down the process. thanks!
|
|
|
|
|
Re: default value for dates [message #186222 is a reply to message #185726] |
Mon, 07 August 2006 02:17 |
|
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
I suggest using either 1901 or 1801 as your year. Using 0001 has issues when you come to do the number of days between particular dates. Most calendars changed by around 16 days between the mid-1500s and the mid-1600s. NEVER use 0000 as a year as it did and does not exist.
David
|
|
|