×

FormatDate Function

FormatDate allows you to easily format a date, including setting the text value for dates that have not been set (#12AM#).

FormatDate(ByVal Value As Date, ByVal FormatString As String, ByVal ReturnIfEmpty As String)

Examples:

  • Date - FormatDate(Now,"MM/dd/yy","")
  • Date, ASAP for blank - FormatDate(DateValue,"MM/dd/yy","ASAP")
  • DateTime - FormatDate(Now,"MM/dd/yy mm:ss","")