Greetings, I am trying to use dates to schedule pick up and drop off times for an event. I am having the toughest time creating relations. I am wondering if the format of the date makes any difference, meaning:
When I input dates by hand into sheets and click on them to expand them, they look like this:
However, when the user enters it from the date picker, it looks like this:
Might that affect my ability to create a relation between them? I ultimately would like to place users into certain time slots for pick up based on when they arrive, but the dates seem to work a bit differently and none of my if-then-else statements even work. I am wondering if there is something special I need to do because it involves dates and I have spent days trying all the tutorials and reading the How To section.
To use dates/times to create relations, it’s best to first convert them to strings or integers.
There are several ways to do this. Possibly the easiest is with the Format Date plugin. However, a word of warning - that plugin is known to give inconsistent results when dealing with non-US date formats.
For that reason, I avoid it and what I usually do is use a series of math columns to extract the parts that I need (year/month/day) and then stitch them back together using a template column. So I’ll wind up with something in yyyy-mm-dd format, which I then use to build a relation.
)
