Basic use case:
I have a relatively simple collection where I need to store documents and each document has a “due date”.
From the end user perspective, the due dates are always on wednesdays America/New_York time.
I need to send out an email every wednesday with what the documents that are “due” that day. The email goes out in the morning America/New_York time.
My question:
What’s the optimal way to store/retrieve this stuff?
The due date could be set anywhere (in browser or in our server app), and so if I don’t explicitly set it, it’ll use UTC local time (I think). These are node/javascript environments running on aws.
As a result, it seems like the smartest thing to do would be to store them as UTC (e.g. 2021-12-02T00:00:00.000+00:00) and then when I do my wednesday email to query using an offset of -5 hours?