Results 1 to 2 of 2
  1. #1
    rohandgac2013 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2015
    Posts
    1

    Query on how to identify dates prior to a specific date mentioned by developer.

    I want to identify dates prior to a specific date mentioned by user/developer. Say I have a list of dates e.g 17-12-2014,03-01-2015,10-11-2014,02-02-2015,05-03-2015,16-03-2014. I want to show dates prior to 01-01-2015 and after that I want to apply dates prior to 01-01-2015 in another query. Please help on my question.

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Have a look here, specifically the "Working with Dates" section: http://www.fontstuff.com/access/acctut06.htm

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 20
    Last Post: 01-13-2015, 02:23 PM
  2. Need to pull query for 2 Status with recent and prior dates
    By undefatedskillz26 in forum Queries
    Replies: 7
    Last Post: 12-23-2014, 03:33 PM
  3. Replies: 3
    Last Post: 08-20-2014, 01:47 PM
  4. Replies: 1
    Last Post: 11-22-2013, 12:30 PM
  5. Replies: 13
    Last Post: 09-27-2010, 03:10 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums