need help to creat a Query for Futre date?

[YaseenIskaf]

Kindly I need a help to create a query which is showing the Employees’ documents Expiration after 2 Months from the System date?

for Example I need to sort out all the employees which their passport will expired after 2 Months (with out to Enter the no of month)

thanks all

[recyan]

Let us say, we have :

PassportID | DateOfExpiry | DateAfter2Months
1 | 10/18/2012 | 10/18/2012
2 | 9/18/2012 | 10/18/2012
3 | 11/18/2012 | 10/18/2012

Which PassportID's do you want the query to show ?
1) If the data is not proper or sufficient to explain the problem, pls post some data & the results you want.
2) Additionally, you can check out : Date(), DateAdd() and IIf()

Thanks

[YaseenIskaf]

thank you recyan Dear for your reply ASAP

i will give you an example below and i will use today date as a System date

Passport NO | Expiry date
1 | 17/6/2012 (past date to be Show)
2 | 17/8/2012 (Curent date to show)
3 | 20/9/2012 (in Betewwn to show)
4 | 17/10/2012 (till 2 Months to show)
5 | 18/10/2012 (more than 2 Months to not show)

for 1 and 2 it is <= date()
but how for the all records which will expired untill next 2 months

thank you again

[recyan]

Check out if below gives some guidelines.

SELECT 
    tblPassports.PassportID, 
    tblPassports.DateOfExpiry, 
    DateAdd("m",2,Date()) AS DateAfter2Months, 
    IIf([DateOfExpiry]>=[DateAfter2Months],"Do Not Show","Show") AS CheckIfWithin2Months
FROM 
    tblPassports;

SELECT 
    tblPassports.PassportID, 
    tblPassports.DateOfExpiry, 
    IIf([DateOfExpiry]>=DateAdd("m",2,Date()),"Do Not Show","Show") AS CheckIfWithin2Months
FROM 
    tblPassports
WHERE 
    (
        (
            (IIf([DateOfExpiry]>=DateAdd("m",2,Date()),"Do Not Show","Show"))="Show"
        )
    );

Thanks

[YaseenIskaf]

thank you
your answered support me to find it

this code <=DateAdd("m",2,Date())

I tried and works same how i need the result

Thank You again

[recyan]

Glad you found it helpful.

Thanks

[YaseenIskaf]

Dear how to solve this problem with my db which i created by Access 2007 but doesn`t works with other system 2010 or even 2007 the Error box saing (Your Micrsoft office Access db or project contains a missing or broken reference to the file 'RulesEngine.dll' version 1.0.
and other View *.dll files all the Query order related to the Date not working
the db workes only in the same system which was created by with Access 2007 but even in other computer with same Access 2007 doesnt workes

please help me to solve my problems

[recyan]

Would suggest starting a new thread in appropriate forum, as this is a different problem.
You will get more responses.
Do not know if the Mod's can split this thread & start a new one for above.


Edit : Noticed, you have already started a new thread
https://www.accessforums.net/program...lem-27546.html

Thanks