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 is DDMMMYYYY, or for today's date: 19SEP2022.  I would guess this question may have been asked before - but I'm having trouble converting the numeric to alpha for the month if a use a to formatted text field.  Any help would be appreciated, in this approach or any other ideas?

Thanks,
Sarah

------------------------------
Sarah Kuligowski
------------------------------
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
      ------------------------------