Forum Discussion
Token Comma Expected Error
I am trying to add a custom column in a table to calculate the difference between the date when an order is closed against when the order was opened. Below is my formula. I am getting a Token Comma Expected Error, when I click the link to show the error it displays where I have marked the "T" red in my DATEDIFF expression. I am not sure what this error means and why it would display on a single letter in my expression.
IF(Orders[[ClosedDate]>0,DATEDIFF(Orders[ClosedDate],Orders[Date],DAY),DATEDIFF(TODAY(),Orders[Date],DAY))
Hey Dane ,
right after the if you have 2 brackets Orders[[ClosedDate].
Can you try to remove one of them?:
New Column = IF( Orders[ClosedDate] > 0, DATEDIFF( Orders[ClosedDate], Orders[Date], DAY ), DATEDIFF( TODAY(), Orders[Date], DAY ) )As you just want to get days you can also just subtract the the dates:
New Column = IF( Orders[ClosedDate] > 0, Orders[Date] - Orders[ClosedDate], Orders[Date] - TODAY() )If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
3 Replies
Hey Dane ,
right after the if you have 2 brackets Orders[[ClosedDate].
Can you try to remove one of them?:
New Column = IF( Orders[ClosedDate] > 0, DATEDIFF( Orders[ClosedDate], Orders[Date], DAY ), DATEDIFF( TODAY(), Orders[Date], DAY ) )As you just want to get days you can also just subtract the the dates:
New Column = IF( Orders[ClosedDate] > 0, Orders[Date] - Orders[ClosedDate], Orders[Date] - TODAY() )If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovicThanks for the quick reply. I subtracted the dates from each other as you specified in your example, there were no syntax errors, I deployed the change and am getting the error message below saying the name "IF" was not recognized, its asking me to make sure it was spelled correctly, do you know what may be causing this?
