IsFieldDateWithReformat

Confirms that the data of a field is a valid date and then formats the Date value according to the format entered as the parameter.

Syntax

bool IsFieldDateWithReformat (StrParam)

Parameters

The Date format you want to use.
  • mm/dd/yyyy
  • mm/dd/yy
  • dd/mm/yy
  • mm.dd.yy, etc.

Defaults to system short date format if no format or single * is used. Smart parameters are supported.

Returns

False if the parameter is invalid, or the current field value is not a valid date given the specified format. Otherwise True.

Level

Field level.

Details

Example
IsFieldDateWithReformat("*")
June 3, 2002 becomes 06/03/2002

IsFieldDateWithReformat("mm.dd.yy")
June 3, 2002 becomes 06.03.02