Results 1 to 5 of 5

Conditionally formatting a mm/dd/yyyy*

  1. #1
    Steve3415 is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    3

    Post Conditionally formatting a mm/dd/yyyy*

    I have been asked to easily show the difference between a planned and actual date in a report. The request is to have the planned date show up RED and with and "*" by the date. I have created the expression,



    Planned IR Date*: IIf(Nz([Planned IR Date])=0,"No Date",[Planned IR Date] & "*")

    I have been using conditional format in the report, but cannot this to work yet. By the way, I am a newbie to Access.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    41,542
    Why doesn't work - error message, wrong results, nothing?

    Your Nz syntax is wrong, doesn't have alternate value.
    IIf(Nz([Planned IR Date],0)=0,"No Date",[Planned IR Date] & "*")
    To provide db: Make copy, remove confidential data, run compact & repair, zip w/Windows Compression if over 500KB (2MB zip allowed), attach to post. Attachment Manager is below the Advanced post editor window, click Go Advanced below the Quick Reply window.
    If any suggestion resolves your issue, please use the Thread Tools dropdown above first post and mark as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  3. #3
    Steve3415 is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    3
    Quote Originally Posted by June7 View Post
    Why doesn't work - error message, wrong results, nothing?

    Your Nz syntax is wrong, doesn't have alternate value.
    IIf(Nz([Planned IR Date],0)=0,"No Date",[Planned IR Date] & "*")

    Sorry, instead of pasting I typed. It is supposed to be Planned IR Date*: IIf(Nz([Planned IR Date])=0,"No Date",[Planned IR Date] & "*")


    I am using the expression to put an asterisk with the date if the space is Null due to a lack of information. I am not sur what I should be conditionally formatting for. I just know if the cell contains a "5/25/2012*" I want it to be Red. If it is just 5/25/2012 it need to be black.

  4. #4
    Steve3415 is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2012
    Posts
    3
    By the way...

    To date the conditional formatting I have tried has produced nothing. Like nothing happened.

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    41,542
    That is the same expression as the original post and still wrong. Look at my example again. An alternative:
    IIf(IsNull([Planned IR Date]),"No Date",[Planned IR Date] & "*")
    To provide db: Make copy, remove confidential data, run compact & repair, zip w/Windows Compression if over 500KB (2MB zip allowed), attach to post. Attachment Manager is below the Advanced post editor window, click Go Advanced below the Quick Reply window.
    If any suggestion resolves your issue, please use the Thread Tools dropdown above first post and mark as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

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

Similar Threads

  1. Replies: 5
    Last Post: 05-02-2011, 10:02 AM
  2. Replies: 2
    Last Post: 04-20-2011, 12:50 PM
  3. Replies: 12
    Last Post: 03-09-2011, 03:16 PM
  4. InputMask yyyy-mm for Label
    By smaky in forum Queries
    Replies: 5
    Last Post: 11-03-2010, 09:20 AM
  5. Convert to MMM/YYYY
    By Brian62 in forum Queries
    Replies: 10
    Last Post: 08-31-2009, 03:54 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
  •  
Tech Forums: Microsoft Office Forums