Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
No Problem
var text MM = Right(ToText(Month([Date])),2);
var text DD = Left(ToText(Day([Date])),2);
var text YYYY = IF(Year([Date]) = Year(Today()), ToText(Year([Date]));
If(IsNull([Date]), "",
List("/", $MM, $DD, $YYYY)
var text MM = Right(ToText(Month([Date])),2);
var text DD = Left(ToText(Day([Date])),2);
var text YYYY = IF(Year([Date]) = Year(Today()), ToText(Year([Date]));
If(IsNull([Date]), "",
List("/", $MM, $DD, $YYYY)