Day/Date based list sorting

Same. I’m trying to show a list of events for “this week” and “next week” that a user creates in a form…I was able to set the form date automatically (How do I calculate an event date for the next monday? (forms)) but haven’t been able to figure how to have the date for “next monday” to be shown on the UI since it’s calculated…

here’s what I mean…

image

The calculated field just shows up as “unix time” aka something like…18519.16666666668

It seems like I need:

  1. to be able to update the date picker field with magic text
  2. to be able to format a text box as a date when magic text is used

Neither of those are options right now and so I’ve been trying to figure out how to do create a hacky way of doing this by inserting a blank update page in the beginning of my workflow to update these dates, but haven’t found anything I like.

I feel like there could be an incredibly obvious way to solve this that i’m just overlooking right now, but haven’t been able to figure it out yet.