Topic profile page for Week number.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Week number.
Topic "Week number" was discussed 2,068 times on 416 sites in last 3 months
Started 2 weeks, 1 day ago (2009-11-17 10:29:00)
by Developer_Designer
We have an object [Case Dt(truncated)]. From there we can get week number of the year using Week () function. For example, 10/10/09 it gives 41 and 11/07/09 it gives 45. Currently we have only data for 2009. My question is, if there is any data for 2006, 2007 and 2008, how can I combine the week number and year together ? Something like, 44, 2008, ................46, 2009 ...
Started 2 weeks, 2 days ago (2009-11-16 18:15:00)
by h2fcell
Iâd like to build the following expression in my query GetStartWeekNumber(DatePart("ww",[EnteredDate]), Year([EnteredDate])) So if EnteredDate = 11/3/2009 the function would return 11/1/2009 But GetStartWeekNumber does not exist as an Access Built-In Function. Is there another way to do this as an expression in a query? Iâm not familiar with creating my own functions. Thanks.
Started 2 weeks, 2 days ago (2009-11-16 09:14:00)
by h2fcell
I’d like to build the following expression in my query GetStartWeekNumber(DatePart("ww",[EnteredDate]), Year([EnteredDate])) So if EnteredDate = 11/3/2009 the function would return 11/1/2009 But GetStartWeekNumber does not exist as an Access Built-In Function. Is there another way to do this as an expression in a query? I’m not ...
Started 2 weeks, 5 days ago (2009-11-13 06:14:00)
by ic ic
Hi, I need help. I need to get the week number of day, like the VB Function: [code] DATEPART("ww", Now()) [/code] I tried this but it does not calculate correctly as when the 1st is on Saterday (week1) & calculates on the 3rd Monday the below code sees it as still part of week1 & not week 2 [code] WeekOfYear = Convert.ToString(Math.Ceiling(Convert.ToDouble(Man ufactureDateVar.DayOfYear...
Started 2 weeks, 5 days ago (2009-11-13 05:56:00)
by ismailc
Hi, I need help. I need to get the week number of day, like the VB Function: Code: DATEPART("ww", Now()) I tried this but it does not calculate correctly as when the 1st is on Saterday (week1) & calculates on the 3rd Monday the below code sees it as still part of week1 & not week 2 Code: WeekOfYear = Convert.ToString(Math.Ceiling(Convert.ToDouble(...
Started 2 weeks, 5 days ago (2009-11-13 04:52:00)
by Ismailc
Hi, I need help. I need to get the week number of day, like the VB Function: [code] DATEPART("ww", Now()) [/code] I tried this but it does not calculate correctly as when the 1st is on Saterday (week1) & calculates on the 3rd Monday the below code sees it as still part of week1 & not week 2 [code] WeekOfYear = Convert.ToString(Math.Ceiling(Convert.ToDouble(Man ufactureDateVar....
Started 1 day, 10 hours ago (2009-12-01 11:25:36)
by tytewurk
[b]CAAH[/b]...LOTTO NUMBER RELEASED NEXT WEEK [b]ECRO[/b]... EXPECTING ANOTHER DIVIDEND PAYOUT IN JANUARY (DO SOME DD AND YOU MAY SEE SOMETHING YOU LIKE)... ADD TO WATCHLIST
Started 1 week ago (2009-11-25 09:41:00)
by Judy Gleeson \(MVP Outlook\)[_651_]
yes. the setting is at Tools | options | Calendar .... -- Regards Judy Gleeson MVP Outlook www.judygleeson.com www.deskdoctors.com Are you sick of bad email practice? Get a copy of my paper "Implementing Email Policy" from the Desk Doctors website. "Swede" wrote in message ... Can I get the week number displayed in outlook?
Started 1 week ago (2009-11-25 09:41:00)
by Judy Gleeson \(MVP Outlook\)[_1193_]
yes. the setting is at Tools | options | Calendar .... -- Regards Judy Gleeson MVP Outlook www.judygleeson.com www.deskdoctors.com Are you sick of bad email practice? Get a copy of my paper "Implementing Email Policy" from the Desk Doctors website. "Swede" wrote in message ... Can I get the week number displayed in outlook?