Date and Time data structuring

It sounds like what you are looking to do can be achieved through two things:

  • nested repeating groups
  • date/time :formatted as mm/dd/yyyy

Dates (or more precisely datetime objects) are basically agnostic numbers that represent a point in time. These dates can be expressed as text in your browser such as a date like 8/5/2019 or as a time 6:00PM or both 8/5/2019 6:00PM The user’s browser is in charge of what date and time will be displayed based on the local time zone.

Understanding that your dates are a points and also numbers is important because what you are asking for is to see if your dates are contained in between two date point numbers that make up a day (12:00:00.000AM 8/4/2019 EST and 11:59:59:999PM 8/4/2019 EST)

There are a few ways to what you want, such as trying to setup date ranges for each day and checking if your date point exists between them, but its likely overly cumbersome for your purposes.

A much simpler way to do what you want is to convert your dates to a mm/dd/yyyy texts on the page so you can work with them more easily as whole dates (your dates will remain saved as dates in the db or wherever).

Once you have a list of ‘whole date texts’ you can perform bubble operations and evaluations on those texts such :unique items which give you a list of unique date texts. Once you have that, you can run another search of all dates:converted to mm/dd/yyyy to see what matches.

Here is the an Example Application as well as the Editor

Also, don’t forget about timezones. Your dates are just agnostic numbers. The browser sets the date and the time of how dates are entered and displayed. If your user is entering 9:00PM in New York (EST), that would be grouped under the following day’s date for users looking at the same page in London (UTC)

4 Likes