topic Re: Get month name so i can display it in Discussions

Get month name so i can display it

Yass — Mon, 08 Jul 2024 14:55:41 GMT

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)) || "%"
    );

Re: Get month name so i can display it

jthi — Mon, 08 Jul 2024 14:59:27 GMT

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);

Re: Get month name so i can display it

Yass — Mon, 08 Jul 2024 15:11:07 GMT

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 ?

Re: Get month name so i can display it

jthi — Mon, 08 Jul 2024 15:25:20 GMT

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())];

Re: Get month name so i can display it

hogi — Mon, 08 Jul 2024 16:30:49 GMT

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 ....)

Re: Get month name so i can display it

Yass — Tue, 09 Jul 2024 07:30:23 GMT

Thank you! Using Locale(0) worked perfectly.