In some applications, dates can be entered manually as a date, or also as year/week (where we then calculate the first date of this week). We also use this for periods as well (year/period).

How would you align the values in a grid? And how should header labels be aligned then?

We also have combinations like From Year/week and To year/week. How would you show these (separate fields or like format YYYYWW)?

  • When the dates appear in a grid, is there a need to sort the dates by period, week, or year alone? Commented Nov 13, 2012 at 11:53
  • A user can edit data in a grid. So it is not really for sort alone.
    – Kim
    Commented Nov 13, 2012 at 12:41

1 Answer 1


What is it that the users are looking for? Are they trying to determine differences / similarities, missing data, specific data? And are they looking for differences in the WW or the YYYY?

@Benny suggested right aligning the dates, but I have to disagree with that. The example given is not easily scannable. Rows 4 and 6 carry (approx) the same visual weight, but they couldn't be further apart in value. Rows 4 and 5 are the same date, but row 5 is holding more visual weight due to its length. This works in spreadsheets for numerical values, because left-aligned values with enough zeros like 1 million and 10 million look pretty similar. It isn't until they are right aligned that we can easily visualize the numeric differences.

So, figure out the goal of the user and craft your grid to aid in that. Are they looking for dates without a WW value? Are they looking for dates that fall within a range? Determining the goal may answer the question of alignment and how many cols to use.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.