Forum Discussion
QuickBaseCoachD
9 years agoQrew Captain
sujre, no problem
var date DateWords = [My Date Field];
var text Month = Case(Month($DateWords),
1, "January",
2, "February",
3, "March",
4, "April",
5, "May",
6, "June",
7, "July",
8,"August",
9,"September",
10,"October",
11,"November",
12,"December");
var MMMDDYYY = $Month & " " & ToText(Year($DateWords));
if(IsNull([My Date Field]), "n/a", $MMMDDYYY)
var date DateWords = [My Date Field];
var text Month = Case(Month($DateWords),
1, "January",
2, "February",
3, "March",
4, "April",
5, "May",
6, "June",
7, "July",
8,"August",
9,"September",
10,"October",
11,"November",
12,"December");
var MMMDDYYY = $Month & " " & ToText(Year($DateWords));
if(IsNull([My Date Field]), "n/a", $MMMDDYYY)