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?