My app does not require knowing the hour, just the day. However, whenever an entry is made with the date it will add the hour making it 12am of the day selected. The problem created is when using formulas to select data based on a date equal to or less than.
I can work around this issue with the extract functionality but would prefer to simply not deal with hours.
A date is a time and there’s no way to get around it.
For filtering data by ‘ equal to or greater than’ or ‘less than’ dates I typically use the ‘Date/time:change hours to 0 change minutes to 0 change seconds to 0’ method.
This topic was automatically closed after 70 days. New replies are no longer allowed.