Forum Discussion
QuickBaseCoachD
Qrew Captain
You can make a new field called month and use that on the form.
Case(Month($MyDate),
1,"JAN",
2,"FEB",
3,"MAR",
4,"APR",
5,"MAY",
6,"JUN",
7,"JUL",
8,"AUG",
9,"SEP",
10,"OCT",
11,"NOV",
12,"DEC")
Case(Month($MyDate),
1,"JAN",
2,"FEB",
3,"MAR",
4,"APR",
5,"MAY",
6,"JUN",
7,"JUL",
8,"AUG",
9,"SEP",
10,"OCT",
11,"NOV",
12,"DEC")
MikeMike
7 years agoQrew Cadet
That worked perfectly! Thank you! :) We couldn't work out how to do it in a field so had guessed it would need to be coded into the Exact form somehow, but that works really well.