Convert a String to a Date With Date()

 

The Date() function converts a string to a date. When doing so, the separator is evaluated accordingly:

Example:

Date ("04.07.1776")                Result: 04.07.1776