Forum Discussion
Resulting NaN when calculating between two dates
Hi, Everyone Stay safe. I am using SharePoint Online lists. 1. The 'DueDate' column is manually typed in date&time format. 2. The columns 'TODAY2' and 'TODAY' are automatically genera...
Hi,
I do see some empty values on the 'DueDate' column, are you sure that the column will have no empty values, because if the created works then your column should unless there is an empty value.
I do see some empty values on the 'DueDate' column, are you sure that the column will have no empty values, because if the created works then your column should unless there is an empty value.
Hi,
Hope you are doing well.
Do you mean space between the column name 'DueDate' or dates in the column?
(1) If you are talking about 'DueDate', 100% sure there is no space.
(2) If you are talking about the dates in the column, the actual values are yyyy-MM-dd without space. The symbols are just JSON formatted ones. I was also wondering if it could fail my expectation. So, I tested using the column '계약 시작일' which did not have JSON. The result was the same.
Thanks for your help.