CochiseCounty
asked on
TimeOfDay() returns 1/1/0001
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.