Date Parameters in Query
Some great info in your book, thanks.
I have discovered an error however:
If you define a Parameter as a Date or Date with Time and the parameter field is not populated then instead of the parameter value being NULL as stated access Web apps return the SQL Server default for an undefined date that being 1/1/1900 12:00:00am.
So the partial SQL string listed on page 254 of:
"... OR [pdatScheduleDateFrom] IS NULL...
will NEVER be true!
What suggestions do the authors have to better match an empty entry?
OR [pdatScheduleDateFrom] ="1/1/1900 12:00:00am" ???