Hi,
I'm using Access 02 database for my small VB.NET Attendance Roll web application. In my database I store the day and time as DATE/TIME field, when someone logs in. Only one login is allowed per day. Now my question is, instead of just displaying the days and time from the database, I want to display only the logins that occurred Monday through Thursday (Fri,Sut,Sun should not be displayed), and second which I really have hard time with is, that I want to display also the Dates/days missed. I need to display any date that is not in the database, and that is not FRI,SUT, or SUN. I do everything in code e.g. dataSet, dataBindings, and use 3 layer approach (Application, Biasness Layer, DataLater(read/write to database).
<> comments
e.g. Output-----
NOW---
DATE TIME
---------------------------
10/23/2003 10:10:50 AM
10/22/2003 11:10:50 AM
10/20/2003 09:10:50 AM
10/19/2003 07:10:50 AM <SUNDAY>
SHOULD LOOK LIKE----
DATE TIME
---------------------------
10/23/2003 10:10:50 AM
10/22/2003 11:10:50 AM
10/21/2003 APPSENT <MISSED DAY>
10/20/2003 09:10:50 AM
<does not display Sunday>
DATABASE----
PKey SID TimeIn IP
-----------------------------------------------
1 884579 0/20/2003 07:10:50 AM 0.0.0.0
1 884588 0/19/2003 09:10:50 AM 0.0.0.0
Any help greatly appreciated.
I'm using Access 02 database for my small VB.NET Attendance Roll web application. In my database I store the day and time as DATE/TIME field, when someone logs in. Only one login is allowed per day. Now my question is, instead of just displaying the days and time from the database, I want to display only the logins that occurred Monday through Thursday (Fri,Sut,Sun should not be displayed), and second which I really have hard time with is, that I want to display also the Dates/days missed. I need to display any date that is not in the database, and that is not FRI,SUT, or SUN. I do everything in code e.g. dataSet, dataBindings, and use 3 layer approach (Application, Biasness Layer, DataLater(read/write to database).
<> comments
e.g. Output-----
NOW---
DATE TIME
---------------------------
10/23/2003 10:10:50 AM
10/22/2003 11:10:50 AM
10/20/2003 09:10:50 AM
10/19/2003 07:10:50 AM <SUNDAY>
SHOULD LOOK LIKE----
DATE TIME
---------------------------
10/23/2003 10:10:50 AM
10/22/2003 11:10:50 AM
10/21/2003 APPSENT <MISSED DAY>
10/20/2003 09:10:50 AM
<does not display Sunday>
DATABASE----
PKey SID TimeIn IP
-----------------------------------------------
1 884579 0/20/2003 07:10:50 AM 0.0.0.0
1 884588 0/19/2003 09:10:50 AM 0.0.0.0
Any help greatly appreciated.