display only month and year from date created
Originally posted by in the former community durning migration: Asked by Jay 20 days ago I think this is a super simple formula, but for some reason it does not work in a formula field. I belie...
Forum Discussion
Answer
Was this answer helpful?
Answer posted by:
QuickBaseCoach App Dev./Training , Mark Shnier, Principal
QuickBase Solution Provider 20 days ago
Try this. I have commented out the part that would normally put in the day of the month
var date MyDate = ToDate([Date Created]);
List("-",
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"),
//Right("0" & ToText(Day($MyDate)),2),
ToText(Year($MyDate)))
Was this answer helpful?
Answer posted by:
QuickBaseCoach App Dev./Training , Mark Shnier, Principal
QuickBase Solution Provider 20 days ago