KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: Improved validation for the Date command
PRODUCT: 4D | VERSION: 14.1 | PLATFORM: Mac & Win
Published On: July 14, 2014

Date function takes in a date string. Ex(“6/9/14”).
The Date function in v13 and v14 now check to see if the date string passed in is a valid date. The validity of the date is determined by the System’s format. For example, a system with the English (US) format will expect a date “mm/dd/yyyy”. If the date string passed is an invalid date, the null date (!00/00/00!) will be returned. Below are a few examples comparing the results of v12 vs v13 and v14.