I am using TimeOf Day to retrieve the current time, but it returns something like
1/1/0001 11:33:35 AM
And I use NOW() to return the current Date, but it returns the time also.
How do I get the date only, like 5/23/06 and time only, like 11:33:35 AM
Thanks for help