Results 1 to 10 of 10
  1. #1
    sdc1234 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2013
    Posts
    89

    Hide #NUM in sharepoint

    Greetings,

    =DATEDIF([Today's Date],[Instructor Travel Dates (Start)],"d"

    this works but now im trying to hide the #NUM

    any sugestions

    thanks for your help
    novice

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    How does this work - DateDiff missing an f and closing paren and the "d" parameter is in wrong position - are these just typos in forum post?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    sdc1234 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2013
    Posts
    89
    no typos thats just how sharepoint codes, little different than other codings, still getting used to the way it handles...

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    %*$&Microsoft! Don't they know the meaning of the word 'consistency!!!

    Surely still need closing paren?

    Why would the expression fail and show #NUM?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    sdc1234 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2013
    Posts
    89
    I agree with that 100%
    and you are right about the closing ()
    I thought it was an error on my part but then I noticed when I tried it again that it would only work for the upcoming dates (i.,e start date 10/6 would show up as 3 days remaining ) whereas start date of 10/1 you would think would be a negative but shows up as #NUM, now I am trying to figure out how to hide the #num...

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Access/VBA has an IsError() function.

    Or maybe test if the start date is prior to current date. Are these field names used in the expression?

    =DATEDIF([Today's Date], IIf([Instructor Travel Dates (Start)]<Date(), Date(), [Instructor Travel Dates (Start)]), "d")
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    sdc1234 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2013
    Posts
    89
    =DATEDIF([Today's Date], IIf([Instructor Travel Dates (Start)]<Date(), Date(), [Instructor Travel Dates (Start)], "d")=

    The formula contains a syntax error or is not supported.

    for some reason it doesn't take date(), Me(), or today() functions

  8. #8
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Can SharePoint not capture the current date in an expression?

    This link says Date() and Today() are valid functions http://office.microsoft.com/en-us/su...gs=CH001171117
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  9. #9
    sdc1234 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2013
    Posts
    89
    Yes I have read those as well here is the link I was working off of yet still does not work


    http://abstractspaces.wordpress.com/...ulated-column/

  10. #10
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Well, can't help with that. I've never used SharePoint. No idea why it won't do what it's supposed to.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Using Sharepoint?
    By ayupchap in forum SharePoint
    Replies: 1
    Last Post: 03-27-2014, 01:36 PM
  2. Replies: 0
    Last Post: 03-24-2014, 09:35 AM
  3. Sharepoint?
    By Durks123 in forum SharePoint
    Replies: 1
    Last Post: 12-04-2013, 05:43 PM
  4. Refresh SharePoint List - SharePoint 2010
    By jgelpi16 in forum Programming
    Replies: 0
    Last Post: 08-22-2013, 06:21 AM
  5. Is Sharepoint right for us?
    By kpo in forum SharePoint
    Replies: 2
    Last Post: 10-18-2012, 02:33 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