Convert Date to a special Format

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

I want to have a sort of banner on the form showing which
week of the year we are in.

With Date function I can get today as 12/17/2003 but I
want to see this as 350. 3 indicates that it is year 2003,
50 indicates it is the 50th week of the year. I need this
for planning some activities weekwise.

Thanks
 
Ed

Y2K Lives! What is your intent for displaying your code for the week of
12/17/2013?

You can use the Week() function on the Date() function to get the "50".
You can use the Right() and Year() functions against Date() to get the "3".
You can concatenate these two results.

Good luck!

Jeff Boyce
<Access MVP>
 
Back
Top