Share via

Syntax error when looking at difference between project completion date and today

Sam Hughes 26 Reputation points
2020-12-07T20:24:17.023+00:00

Hi!

I’ve searched the forums endlessly to try and find a solution, we are trying to get Lists to calculate the number of days left between today’s date and when the project is due to complete. I have tried the below formula, replacing with relevant columns, but get syntax error as per image

"=(Number([$DueDate])-Number(@now ))/86400000"

Does any one know how to fix?

45844-4d38b27f-73d5-40e2-a964-9b03991b56ee.jpeg

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,256 questions
Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
10,874 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Elsie Lu_MSFT 9,771 Reputation points
    2020-12-08T02:24:01.76+00:00

    Hi @Sam Hughes ,

    Per my test, I can reproduce your issue. Not sure if this issue is due to a problem with your formula. You can consult the provider of this formula.
    In fact, there are simpler solutions for achieving your goals in SharePoint. And what is the version of your SharePoint?

    Here is a simple demo in my end:
    First, you can create three columns as below, the column type of Duedate and today is Date and Time and intervals is Calculated:
    45958-3.jpg
    Then use =Duedate-today in Calculated formula:
    45984-1.jpg
    At last:
    45959-2.jpg

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments