Week Formatting

hgross · September 30, 2011 5:04PM

I am having some issues changing date formats into weeks with date data. I took a date column, duplicated it to convert to weeks, and now I want to show: "w, M/d"

It is only working for certain rows and I'm not too sure why. Any suggestions?

[Pic attached]

steve · October 1, 2011 5:05AM

The reason is that 'w' requires the date to have a year component. The week number is dependent on the year, because 1 Feb (for example) will be in a different week number for different years, since weeks begin on a set day of the week. The reason you get some results and not others is due to peculiarities of the way Omniscope internally stores dates, but you should not really be allowed to use 'w' outside of the context of a year, at all.

I suggest you use the format "w, M/d/yy" instead.

hgross · October 3, 2011 10:57AM

Thanks Steve! Adding the year worked.

Welcome!

Categories

Ideas Parade

Tagged