Get month name so i can display it

[#1]

I'd like to retrieve the current month's name to display it in my results.

I tried using this function but i get every time the current date in format dd/mm/yyyy  :

current_month = Format(Today(), "Mon");

textbox_result << Set Text(
        "ICT  NOK  %  for " || current_month || " is " || Char(Round(percent_nok_ict, 2)) || "%\!N" ||
        "FCT  NOK  %  for " || current_month || " is " || Char(Round(percent_nok_fct, 2)) || "%"
    );

[#2 · Accepted solution]

You could use Format Pattern

Names Default To Here(1);

opt1 = Format(Today(), "Format Pattern", "<Month>");
opt2 = Format(Today(), "Format Pattern", "<Mmm>");

show(opt1, opt2);

[#3]

That works perfectly, thank you !
I have a quick follow-up question. I successfully retrieved the month, but it's currently in French. Is there a function in JMP that can translate it to English ?

[#4 · Accepted solution]

I'm not sure if << Use Locale(0) would work

Names Default To Here(1);

opt1 = Format(Today(), "Format Pattern", "<Month>", << Use Locale(0));

If not you could create conversion list and use that

Names Default To Here(1);

months = {"Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"};

months[Month(Today())];

[#5 · Accepted solution]

If you use the English version of JMP, a very nasty workaround:

"use JMP language ..."

from the Preferences/Windows Settings.

It will interfere with dozens of other functions (csv import, date in data tables ....)

[#6]

Thank you! Using Locale(0) worked perfectly.