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","")