MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

Divide Dates into Weeks and Months

  • Follow


Hi All,

I have a table that has 3 fields:

OT_DATE
WEEK
MONTH

The purpose of this table is to calculate overtime worked per employee
per week.  I join to the table to an attendance table on the date and
then use this tbale to group by week (so that I can caluclate the hrs
over 40 for each employee).  Is there any way to do this other than
manually adding dates to this table.  It is no big deal, but I didnt
know how other people did this.
1
Reply Matt 5/24/2007 2:07:50 PM

microsoft.public.access 16776 articles. 72 followers.

0 Replies
823 Views

(page loaded in 0.028 seconds)

Similiar Articles:

Divide Dates into Weeks and Months - microsoft.public.access ...
Hi All, I have a table that has 3 fields: OT_DATE WEEK MONTH The purpose of this table is to calculate overtime worked per employee per week. I jo...

Divide a a range of dates into intervals starting with the current ...
Divide Dates into Weeks and Months - microsoft.public.access ... Divide a a range of dates into intervals starting with the current ... Divide Dates into ... access MYSQL ...

Date range in months from month and year fields - microsoft.public ...
Divide Dates into Weeks and Months - microsoft.public.access ... Date range in months from month and year fields - microsoft.public ... Divide Dates into Weeks and Months ...

Convert Week number to Month - microsoft.public.excel.worksheet ...
Divide Dates into Weeks and Months - microsoft.public.access ... Convert date to months - microsoft.public.access.queries ... Divide Dates into Weeks and Months ...

Divide into groups. - microsoft.public.excel.programming ...
Divide Dates into Weeks and Months - microsoft.public.access ... Hi All, I have a table that has 3 fields: OT_DATE WEEK MONTH The purpose of this table is to calculate ...

sort a column by date- by month not year - microsoft.public.excel ...
Divide Dates into Weeks and Months - microsoft.public.access ... sort a column by date- by month not year - microsoft.public.excel ... Divide Dates into Weeks and Months ...

Select all dates in month from month and year in text box ...
check date if it falls within a month - microsoft.public.access ... Divide Dates into Weeks and Months - microsoft.public.access ... check ... Select all dates in month ...

Group by date (month & week) in query - microsoft.public ...
Group by date (month & week ... problems with Days that were at the ... Query to group by week, but display week commencing date (monday of each week) Queries ... into ...

Parsing Out a Month from a date field - microsoft.public.excel ...
Divide Dates into Weeks and Months - microsoft.public.access ... Parsing Out a Month from a date field - microsoft.public.excel ... Divide Dates into Weeks and Months ...

check date if it falls within a month - microsoft.public.access ...
Divide Dates into Weeks and Months - microsoft.public.access ... check date if it falls within a month - microsoft.public.access ... Divide Dates into Weeks and Months ...

Divide Dates into Weeks and Months - microsoft.public.access ...
Hi All, I have a table that has 3 fields: OT_DATE WEEK MONTH The purpose of this table is to calculate overtime worked per employee per week. I jo...

How to Calculate Weeks Into Months | eHow.com
How to Calculate Weeks Into Months. Whether you're counting ... Each fiscal year is divided into... How to Convert a Date Into a Day of the Week

Split month into weeks - by dates - using VBA: split, weeks, vba
Good evening Experts, I am looking for some VBA inventiveness. Across the top of a table I would like the days of a specified month split into weeks. Weeks for this ...

How to Translate Weeks of Pregnancy Into Months | eHow.com
Weeks of pregnancy do not translate exactly into months if you simply divide by four. ... last nine months. This nine months consists of 40 weeks with the date of the ...

Split month into weeks: PHP - Experts Exchange - Your Technology ...
Hi, I'm looking for a PHP function which should split a given month into weeks and when week selected should give date range i.e start date of the week and end date ...

7/20/2012 7:24:57 PM


Reply:
Privacy Policy | All Times Are GMT(UTC) | powered by