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
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
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.
no typos thats just how sharepoint codes, little different than other codings, still getting used to the way it handles...
%*$&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.
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...
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.
=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
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.
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/
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.