Facility Control

Hi!
I'm having some trouble with w.format for DatePicker. There only seems to one format available. I currently have MMM d, yyyy. You can also use MMM dd, yyyy. I used to be able to format DDD MMMM d, yyyy and would get Tuesday November 30, 2021. Now if I use the three Ds, I get the numbered day of the year, in this case is 334. Am I missing something? I've looked through all the help files and the only formatting information deals with timers.

I'm able to use the DDD MMMM d, yyyy in Xpression with no problem. I've also tinkered with it in Visual Logic, but the Date blocks there require the input to come from a date source, but the date from the DatePicker is a string, or outputs the current date.

Thanks in advance for any help.

------------------------------
Rich Worthley
INTERNATIONAL SOUND CORPORATION
------------------------------

This one doesnt make sense to me either...

Well, I did find that if you go into timers, and look at the little ? for "display" there, you will get the time variables, and you can use these in the picker again.
So in your case, "E" would be day, but testing these I was only able to get the first two letters of the day.

But I found another interesting "bug" in this:

Here in norway we start the week on Monday in our calendars, not sunday as is the typical standard in the US.
And making 100% sure I pick the collumn "sat", I would get the correct dates, but my day designation actually comes back in my native norwegian abbreviation "sø" wich in turn stands for søndag (sunday) here. Wich in turn made me wonder.
Now looking at the date I picked, wich is December 12th, in the date picker, it is actually listed as "sat" but I'm fairly certain that if you look at a calendar for this year, you'll find that december 12th is in fact sunday, so the response I get from the script is actually correct with "sø/sun", however the day in the date picker is off by one day.

------------------------------
Aleksander Stalsberg
Lillehammer Icehockey Club
------------------------------

Original Message:
Sent: 11-30-2021 16:49
From: Rich Worthley
Subject: Date formatting DatePicker in Dashboard

Hi!
I'm having some trouble with w.format for DatePicker. There only seems to one format available. I currently have MMM d, yyyy. You can also use MMM dd, yyyy. I used to be able to format DDD MMMM d, yyyy and would get Tuesday November 30, 2021. Now if I use the three Ds, I get the numbered day of the year, in this case is 334. Am I missing something? I've looked through all the help files and the only formatting information deals with timers.

I'm able to use the DDD MMMM d, yyyy in Xpression with no problem. I've also tinkered with it in Visual Logic, but the Date blocks there require the input to come from a date source, but the date from the DatePicker is a string, or outputs the current date.

Thanks in advance for any help.

------------------------------
Rich Worthley
INTERNATIONAL SOUND CORPORATION
------------------------------

Thank you Aleksander! That did the trick. It does return the US standard 3 letter abbreviation for the days of the week, Sun, Mon, etc.

------------------------------
Rich Worthley
INTERNATIONAL SOUND CORPORATION
------------------------------

Original Message:
Sent: 12-06-2021 07:37
From: Aleksander Stalsberg
Subject: Date formatting DatePicker in Dashboard

This one doesnt make sense to me either...

Well, I did find that if you go into timers, and look at the little ? for "display" there, you will get the time variables, and you can use these in the picker again.
So in your case, "E" would be day, but testing these I was only able to get the first two letters of the day.

But I found another interesting "bug" in this:

Here in norway we start the week on Monday in our calendars, not sunday as is the typical standard in the US.
And making 100% sure I pick the collumn "sat", I would get the correct dates, but my day designation actually comes back in my native norwegian abbreviation "sø" wich in turn stands for søndag (sunday) here. Wich in turn made me wonder.
Now looking at the date I picked, wich is December 12th, in the date picker, it is actually listed as "sat" but I'm fairly certain that if you look at a calendar for this year, you'll find that december 12th is in fact sunday, so the response I get from the script is actually correct with "sø/sun", however the day in the date picker is off by one day.

------------------------------
Aleksander Stalsberg
Lillehammer Icehockey Club

Original Message:
Sent: 11-30-2021 16:49
From: Rich Worthley
Subject: Date formatting DatePicker in Dashboard

Hi!
I'm having some trouble with w.format for DatePicker. There only seems to one format available. I currently have MMM d, yyyy. You can also use MMM dd, yyyy. I used to be able to format DDD MMMM d, yyyy and would get Tuesday November 30, 2021. Now if I use the three Ds, I get the numbered day of the year, in this case is 334. Am I missing something? I've looked through all the help files and the only formatting information deals with timers.

I'm able to use the DDD MMMM d, yyyy in Xpression with no problem. I've also tinkered with it in Visual Logic, but the Date blocks there require the input to come from a date source, but the date from the DatePicker is a string, or outputs the current date.

Thanks in advance for any help.

------------------------------
Rich Worthley
INTERNATIONAL SOUND CORPORATION
------------------------------