Can save date time, but not Date formatted as....?

A date :formatted as… is no longer a date. In most cases, it’s a string (text). Don’t save dates that way.

For a good overview of dates - what they are, what the represent, and the differences between date construction and date formatting, see:

1 Like