Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Member
360 Points
60 Posts
Feb 29, 2012 06:23 PM|LINK
If you have an SQL statement to retrieve the data and the data in the date column is NULL but you want today's date, then you can use
COALESCE([nameOfDateColumn], GETDATE())
in the SQL statement.
Andrew Morto...
Member
360 Points
60 Posts
Re: warning error: A null reference exception could result at runtime.
Feb 29, 2012 06:23 PM|LINK
If you have an SQL statement to retrieve the data and the data in the date column is NULL but you want today's date, then you can use
COALESCE([nameOfDateColumn], GETDATE())
in the SQL statement.