Continuing the discussion from Filter Datetime on month or day / advanced Datetime functions:
I guess I am just now realizing that this is not here anywhere (at least that I can find).
Every Database that I have ever worked with before has had Date/Time functions built in. I have the prerequisite of not storing different parts of a DateTime into separate searchable fields. I need to be able to do filtering based upon DateTime that matches a particular month, or a particular day, or a particular hour.
Use Case 1: Filter a list of Contact’s Birthdays that is today. If it is saved as a DateTime scalar with the accurate birth year as is needed for calculating age, then I cannot filter by Date unless I also specify a year.
Use Case 2: Filter a list of Activities that occurred in a particular month, or on a particular date, or on a particular day of week. Building our application, we want to be able to show users when their friends are most active based upon these times. This can be used for schedule matching. If who I am trying to reach is usually active during this time period on these particular days of the week then that is when I will try to reach out to them.
Use Case 3: Filter a list of Events that occurred in a particular month. I want to be able to show what events happened during this month at this location in the years past. Users want to see if maybe there is another similar event that might be going on but is not documented yet. Used for looking forward and planning based on normal activities during a month.
I have more use cases if you need more. Can this be done now with current functions/var blocks?
I am thinking that maybe I could do some math based off from the epoch times to find dates in a specific year/month/hour/DoM/DoY/etc.