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

%3CLINGO-SUB%20id%3D%22lingo-sub-1964655%22%20slang%3D%22en-US%22%3ESyntax%20error%20when%20looking%20at%20difference%20between%20project%20completion%20date%20and%20today%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1964655%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3CSPAN%20class%3D%22Apple-converted-space%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%E2%80%99ve%20searched%20the%20forums%20endlessly%20to%20try%20and%20find%20a%20solution%2C%20we%20are%20trying%20to%20get%20Lists%20to%20calculate%20the%20number%20of%20days%20left%20between%20today%E2%80%99s%20date%20and%20when%20the%20project%20is%20due%20to%20complete.%20I%20have%20tried%20the%20below%20formula%2C%20replacing%20with%20relevant%20columns%2C%20but%20get%20syntax%20error%20as%20per%20image%3CSPAN%20class%3D%22Apple-converted-space%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22%3D(Number(%5B%24DueDate%5D)-Number(%40now))%2F86400000%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20any%20one%20know%20how%20to%20fix%3F%3CSPAN%20class%3D%22Apple-converted-space%22%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1964655%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOneDrive%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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? 

0 Replies