Solved - it was a data quality issue. Once I changed the CSV data to have all dates as dd-MMM-yy format, I am able to convert the field to a date field without issue. Somewhat surprising the Oracle DV app doesn't support this no doubt very common data convert issue, ie automatically from d-MMM-yy to dd-MMM-yy

Phillipe was correct - it was a data quality issue. Once I changed the CSV data to have all dates as dd-MMM-yy format, I am able to convert the field to a date field without issue. Somewhat surprising the Oracle DV app doesn't support this no doubt very common data convert issue, ie automatically from d-MMM-yy to dd-MMM-yy

Ah! The data type is not a date field - looking at the video again that's the only difference. It get's back to the other post I had - about not being able to convert the field to a date as the application can't handle a null or blank field when I try to use the "Convert to Date..." menu option. Any idea on that one as it…

Yes I thought that might be the case but I can't see any issues. Just a normal .csv from Excel...

Hi Philippe, Thanks for sharing the video! I have tried this but it is not working. I have tried first without casting but the calculation does not validate. I then tried with casting. It validates ok and then when I try to add to the canvas it throws an error?.