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