Getting Started

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

    Posted 09-19-2022 22:33
    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 09-20-2022 01:31
    Edited by bharath natarajan 09-20-2022 01:32

    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 09-20-2022 08:31
    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 09-20-2022 09:53
    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
    ------------------------------