Expression Error

[ChubbChubb]

I am adding a custom column to a student membership table

={Number.From([Start_Date])..Number.From([End_Date])}

which when expanded creates a row per date for each student between the 2 date ranges. Essentially copying the same row 365 times per student. The column works but when I then click apply I get the error

OLE DB or ODBC error:[Expression.Error] We canno apply operator .. to types Null and Null.

I have checked and there appear to be no errors or missing data/nulls in the table. How can I fix this?

[Kishore_KVN]

Hello @ChubbChubb ,

Can you explain about the steps you did after expanded columns like if you have used replace values then you have to use in which column you did that and the error is saying that it cannot convert .. into null. so check where two dots are available in which column and fix it first. 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

[ChubbChubb]

I expand the list and then change the type from a number to a date and thats it

[Kishore_KVN]

After changing to date on the top view you can turn on column quality and see the errors which can be fixed or replaced. 

[ChubbChubb · Accepted solution]

I have managed to find the error, it was in a different column that had blanks but wasn't coming up previously.