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------------------------------
Original Message:
Sent: 09-19-2022 22:33
From: Sarah Kuligowski
Subject: 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
------------------------------