Forum Discussion
QuickBaseCoachD
9 years agoQrew Captain
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",
Year([My Date Field]) <= 1977, null,
$MMMDDYYY)
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",
Year([My Date Field]) <= 1977, null,
$MMMDDYYY)
ChristinePratt1
6 years agoQrew Cadet
This formula worked perfectly for me. I do have a question... If I'm working a month behind, how can I modify this formula so that instead of the $MMYYYY showing up as the same month as the [My Date Field], it shows up as a month prior to the [My Date Field]?
------------------------------
Christine Christine
------------------------------
------------------------------
Christine Christine
------------------------------
- AustinK6 years agoQrew CommanderI believe the best way would be to adjust the DateWords variable to be 1 month behind to begin with.
var date DateWords = AdjustMonth([My Date Field],-1);
That should do it for you. I tested it on one date myself and it did work.- ChristinePratt16 years agoQrew CadetThis worked perfectly! Thanks!
------Original Message------
I believe the best way would be to adjust the DateWords variable to be 1 month behind to begin with.
var date DateWords = AdjustMonth([My Date Field],-1);
That should do it for you. I tested it on one date myself and it did work.