SQL Date Format

Hi Apologies if this duplicates another question on this board, but I have not been able to find an answer that solves my problem. I am pulling data from Snowflake with a [DATE] column with standard SQL date format (yyyy-MM-dd, so today is 2025-07-01). Easymorph recognizes this as a date and maintains the same standard format.

However, when I add a column, I cannot return to that SQL format for some reason. For instance, if I add a new column [DATE2] = [DATE] + 7, the result is 08-Jul-2025. I have tried multiple variations of format and date and combinations of the two. I can get close (2025-Jul-08) but I can never achieve 2025-07-08 without converting the date to and leaving it as text. Any suggestions?

Date formats are just a representation of dates in a column. You can pick the requried date format from the column bar (see below).

LOL that was easy!