Bartender Date Function Follow

0
Avatar
Legacy Poster

Hi guys,

 

I'm new to bartender and already found one bug.

 

I'd like to have an output of "week of the year"+"year" in the date format "wwyy". I can set up a costum date format and it worked - once. Right now it's the week 5 means "ww" should format as "05". But it creates "04". In Germany, the first week with the number "01" startet not in 2015 but on the 29th of December 2014. As you might see, this is a bug in the format function, that does not use the system default for the first week of the year but uses always the first week with 7 days.

 

However - to solve this issue I tried to use VBScript but actually I have no idea how to put all the code within one expression. What I can type is

 

DatePart("ww", date, vbmonday, vbusesystem)

but this won't give me an additonal leading "0".

 

So any ideas?

 

Thank you :)

 

3 comments

0
Avatar
Legacy Poster
Comment actions Permalink

I'm not sure I would classify this as a bug.  Outlook 2010 gives you 3 options (1st week = Jan 1st or first 4 day week, or first full week)  As far as I know there is nothing in the operating system that controls week numbers (I could very well be wrong here).  BarTender appears to not have any date control options for the week number and appears to be using the first full week as the start (if your example is true).

 

If anything I would say this would need to be added to the feature request forums.

0
Avatar
Legacy Poster
Comment actions Permalink

Well actually this is no bug. But its country-dependend which settings Windows does use and thus bartender is not using the system default value.

 

However: Do you have any idea about the vb-scripting issue?

 

I saw a whole bunch of scripts in the forum but I cannot type more than one single line?!

0
Avatar
Legacy Poster
Comment actions Permalink

Sorry, I'm blind. Just found the option to use multi-line :rolleyes:

Please sign in to leave a comment.