Forum Discussion

SarahKuligowski's avatar
SarahKuligowski
Qrew Member
3 years ago

Date as alpha numeric field, available for export

Hello, I'm looking for a vary particular date format that can be used in generated reports (hence why the simple check mark field is not sufficient in the field properties dialog).  The date format...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago
Try this formula

var date MyDate = [Natural Date field];  // insert your date field here

var text MMMM =
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");

var text DD = Right("0" & ToText(Day($MyDate)),2);

var text YYYY = ToText(Year($MyDate));

$DD & $MMMM & $YYYY

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
  • SarahKuligowski's avatar
    SarahKuligowski
    Qrew Member
    3 years ago
    Worked like a charm Mark - many, many thanks!!

    I have to say that you have solved so many of my problems through this forum, I'm a huge fan!  Thank you!

    ------------------------------
    Sarah Kuligowski
    ------------------------------