Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.
I don't see any screenshots, or anything else, attached to your post.
You posted this in the MS SQL section. Is DATE_ADD an MS SQL function? It wasn't in the past, but maybe it's been added. From a little searching I did, DATE_ADD seems to be a MySQL function, so maybe this should be in the MySQL zone?
Apart from that, your syntax seems OK, so I don't know why you'd be getting an error. I assume that ARVLDATE is a date or datetime column, and if it wasn't, I'd expect an error on that, not the 2.
Any chance you're using MS SQL and actually using DATEADD, instead of DATE_ADD? The DATEADD arguments would be:
DATEADD(day, 2, ARVLDATE)
James