Date picker showing company fiscal year and week

[jay.l.fisher]

Our users want the standard date picker to show the company's fiscal year and week number next to each week, in addition to the standard calendar dates. The start date for each fiscal year would need to be passed in to the widget so it could calculate week numbers.

That seems like a fairly common requirement. Any tips on how to extend the existing widget? Or has anyone created something similar that they would consider sharing?

[Isomorphic]

Can you clarify, do you want a second date picker icon that offers this different way of picking dates? Or do you want drop-downs for week and year always there? In addition to the text field, or in lieu of it?

Most likely this will be a subclass of CanvasItem, where the Canvas will likely be a DynamicForm incorporating a couple of FormItems.

[jay.l.fisher]

I want the current date picker but expanded to include two columns to the left of showing the fiscal year and week number for each week displayed in the calendar. The heading for those columns should be dropdowns to select a year and week as an alternative to using the existing browse controls to scroll by calendar month or year. The first day of the week would also need to be set to correspond to the fiscal calendar where weeks might start on Monday instead of Sunday.

[Isomorphic]

Definitely the CanvasItem approach mentioned before then. We don't have an existing sample implementation for this but perhaps someone from the community will chime in.

[jay.l.fisher]

Just to clarify, when I say I want the "the current date picker" with a couple of extra columns for showing and positioning by year/week, I mean the date picker that shows a pop-up calendar.

We useTextField="true" on all of our date fields so the user can type in a date or click the icon to select using the calendar. It's on the calendar where we want to show the fiscal year and week number for each week. Each year may have 52 or 53 weeks in it. Some could even be shorter if the fiscal calendar has changed.

I'm thinking of an api something like DateUtil.setFiscalWeekCalendar(myCalendar) where myCalendar is a list of fiscal years and the start date for each. The week number for a given date is the difference in days from the start of the year divided by 7. You can assume that every year starts on the same day of the week. Setting the calendar could also limit the range of dates that could be selected to those included in the calendar.

Would this be a candidate for feature sponsorship?

[Isomorphic]

Possibly.. can you clarify: 'It's on the calendar where we want to show the fiscal year and week number for each week.'

Do you mean you want something like an extra column that shows the week number, to the left of Monday?

[jay.l.fisher]

Yes. Two columns, one for year and one for week number. The fiscal year may not be the same as the calendar year. The column heading should be a drop-down listing the years or week numbers so the user can reposition the calendar by selecting a year or week number. Those dropdowns would be on the same row as the day column headings, Su Mo Tu We Th Fr Sa.

Also, we would want the first day of the week to be based on the fiscal calendar. It looks like the calendar always shows the days across in a row starting with Sunday through Saturday. But if the fiscal year starts on a Monday we would want the calendar to show the days across going from Monday through Sunday.

[jay.l.fisher]

Here is a very rough sketch of what I mean. The first row beneath the Year and Wk column heading could either be input fields or dropdowns for selecting the first year/wk to display. The end result is that the user still clicks on a day in the calendar to select the date, but they can see the fiscal year/week that each week maps to and position the calendar to a selected year/week.

[jay.l.fisher]

Actually, it would probably make better sense to have the input fields (or dropdowns) above the column headings. Here is an updated sketch.

[Isomorphic]

We get the general thrust, but that design now has two year pickers - and when you pick a week it becomes the first week shown right? So the suggests the month control should be removed since what is shown is not a month.

[jay.l.fisher]

I think it still makes sense to show the month and year on the right in the calendar portion. That one is the calendar year. The year on the left is the fiscal year.

And the month on the right can still be the calendar month name. Just like in the current implementation it is the name of the month for which day 1 is showing in the calendar. There may be a few days showing of the previous month (grayed out). In the new implementation there may be a lot more days of the previous month showing, but the month name can still be based on whatever month has day 1 showing in the calendar.

[Isomorphic]

Yes, that makes sense. We'll send a sponsorship estimate shortly.