Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2005
    Posts
    50

    Question Unanswered: "the date two months ago (from today)" ?

    Hi all.

    I'm trying to create an iif statement that basically says:

    If "the date imported" field is greater than "the date two months ago (from today), then update the field to "new", if not update it to "preorder"

    aka

    IIf [tablexyz].[date imported] > "the date two months ago (from today)", "new", "preorder"

    The problem is that I don't know the correct way to indicate this value
    "the date two months ago (from today)".

    Anyone
    Much thanks in advance.
    Who imported me here?

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,468
    Provided Answers: 10
    TheDate = DateDiff("m",-2,date())

    SO

    iif([tablexyz].[date imported] > DateDiff("m",-2,date()),"New","Preorder")
    hope this help

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

  3. #3
    Join Date
    Jan 2005
    Posts
    50
    Got it, thanks for the quick reply.
    Who imported me here?

  4. #4
    Join Date
    Jan 2005
    Posts
    50
    Hm, will an IIF statement work this way?

    IIf(this value is true, then continue on to this next IIf statement)

    aka

    IIf([tablexyz].[Status]="pre", IIf(([Hazel’s Beloved Products File].[QtyOnHand]>0,”new”
    Who imported me here?

  5. #5
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,468
    Provided Answers: 10
    Yeap

    Think the nested iff can only be 2 a max of 255

Posting Permissions

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