Display Current Month in Query

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • vourge
    New Member
    • Jun 2006
    • 1

    #1

    Display Current Month in Query

    Does any body knows how to display automaticaly only the current Month & Year in Query with out entring the Month and Year?
    Last edited by vourge; Jun 29 '06, 05:37 PM.
  • estvil
    New Member
    • Jul 2006
    • 1

    #2
    Originally posted by vourge
    Does any body knows how to display automaticaly only the current Month & Year in Query with out entring the Month and Year?
    Just use the Month and Year function like this : for the current month : Month(now())
    c[/list]for the current year : Year(now())

    I think that will help

    Comment

    Working...