Or precompute the date on insert, there are a dozen ways to refactor the data model and the query, all of which are better than extracting to txt files, a forma

Or precompute the date on insert, there are a dozen ways to refactor the data model and the query, all of which are better than extracting to txt files, a format with no schema and not based on a standard. That would be the direction I would give if a junior dev was attempting this method.