The really cool thing I had discovered is that you can feed it certain types of text and it will figure out the correct date. I just realized you can do the same thing with a date column.
For example, type the following in a date column and it will convert it to the correct date:
will turn into
