Getting Started

 View Only
  • 1.  Date as alpha numeric field, available for export

    Posted 5 days ago
    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
    ------------------------------


  • 2.  RE: Date as alpha numeric field, available for export

    Posted 5 days ago
    Edited by bharath natarajan 5 days ago

    Hi Sarah,

    I hope you get some help from the link below

    https://helpv2.quickbase.com/hc/en-us/articles/4570317130516-About-Localizing-Dates-

    Thanks,



    ------------------------------
    bharath natarajan
    ------------------------------



  • 3.  RE: Date as alpha numeric field, available for export

    Posted 5 days 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
    ------------------------------



  • 4.  RE: Date as alpha numeric field, available for export

    Posted 5 days 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
    ------------------------------