SQL Server Report Builder 2008 2.0 Get Current date

davidjgray308
davidjgray308 used Ask the Experts™
on
Hi All

I am using the above with SQL Server 2008 Express to try to get a report of all records in a table that have a date equal to the current date and of course for this to change dynamically like the Excel Today() function but have been unable to work out what the built in function is.  Any ideas - the database field is a date field formatted as yyyy-mm-dd.  Many thanks in anticipation.

David
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Compare the database field against  CAST(GETDATE() AS date)

Author

Commented:
Just tested and that looks to be working fine.  Many thanks.

David

Author

Commented:
It worked and was easy to implement A+++.  Not sure why EE is awarding zero points tho.
You are welcome David!  Zero points were assigned to your comment by some mistake, my points are OK.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial