View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lambi000 Lambi000 is offline
external usenet poster
 
Posts: 18
Default Today's Date in MS Query

How do I query on today's date. I apparently have the wrong syntax because
I'm constantly getting error messages.

In the criteria, I have =Today(). What are the exact characters I should be
putting in the criteria box to get todays date only? I do not want the user
typing in the date every time he refreshes data.

Thanks for the help.