SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast Shane Is My Name's Avatar
    Join Date
    Oct 2009
    Location
    New York
    Posts
    65
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Access 2010 does not allow date() in queries anymore. So how do u find current date?

    My query used to have this: DaysUntilExpire: [Expires]-Date()

    "Expires" was a field from the table, but "date()" would grab the current date. This worked in access 2003 and 2007. However in 2010, they do not allow this to grab the date anymore...

    I checked all over online and most references say to use a datepicker now.. but the datepicker would be used in a form, but im using a query.. I can not find anywhere to figure out how to calculate the current date within a query... (access 2010)...

    Does anyone know how to do this now?

    *FYI... in older versions, you could just use the following: =date()
    but now that does not work.
    Shane

  2. #2
    SitePoint Author silver trophybronze trophy
    wwb_99's Avatar
    Join Date
    May 2003
    Location
    Washington, DC
    Posts
    10,633
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Make the concept of date since a variable and pass it in as a parameter.


Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •