hi all,

is me again. :(nobody reply my last post. but is ok, i have solve it oeldi.now i have another probelem deal with the date.i hope can get some help from u all
i have to textbox to let the user insert the start date and end date and then one checkbox to let the user checked whether they wan to apply the half day leave or not.
after user click submit button, it will calculate the total leave at the backend, then display the applicaiton information again before insert into the DB.
i will prepare another module to let the admin add on when is the public holiday.
the question is:
how can i retrieve the date from the start and end date from the user input and then compare with the public holiday.
if the date they applied involve the public holiday, then the total leave they apply will reduce due to the public holiday.
do u all have any idea?can guide me more.
i feel guilty to bring u all alot of problems as i m a beginner of ASP and also jz learn how to do a system..

hope to hear from u soon.
thank you. :)

Good day.

NOTE: There is no VBScript date function I am aware of which can find dates within a given date range.

You can achieve this using an SQL statement providing your public holiday dates are stored in a database table, I would reccomend this. How would I do it - set up a table like so:

pulicHoliday (tble name)
ID (an auto incrimenting primary key)
phDate (smallDateTime, no nulls)
inactive (bit, no nulls, default insert of 0)

Throw some dates in there for now which represent public holidays.

Now onsubmit of your user form you will have a start date and an end date, so:

sql = "SELECT count(phDate) FROM pulicHoliday WHERE phDate >= '" & trim(request.form("startDate")) & "' AND phDate <= '" & trim(request.form("finishDate")) & "';"

This will give you the number of days to subtract, to calculate the result:

response.write "You have " & (DateDiff("d", trim(request.form("startDate")), trim(request.form("finishDate"))) - [theResultFromYourQuery] ) & " days leave."

Wind is your friend
Matt

hi mat41,
i have write a code to match if the date between start and end date have sat and sun, it will minus 2 days from the total days.
then i write one more code as u teach me to get the total day of public holiday. if got public holiday match with the date then it will minus the days again.
how bout if the public holiday at sat and sun?
how is it work?:(
plz guide me again.
thank you.:)

One way would be to add another bit field (no nulls, default value of 0) lets say called satSun. set this to true for all days which fall on a sat or sun. Now change your query to:

sql = "SELECT count(phDate) FROM pulicHoliday WHERE phDate >= '" & trim(request.form("startDate")) & "' AND phDate <= '" & trim(request.form("finishDate")) & "' AND satSun=0;"



Wind is your friend
Matt

hi mat41, thanx for ur kind response.i have solve it.thank you very much.but...i have another problem is:

i wan to validate if the start date or end date is same as the public holiday.it will have an alert.
i do it using server side script after submit.
first i call out the record that store the public holiday date.
set rsholy =server.createobject("ADODB.Recordset")
sqlholy = "SELECT holydate FROM publicholiday (DATEPART(w, holydate )<>'7' AND DATEPART(w, holydate )<>'1')"
rsholy.Open sqlholy,conn
then
<% if startdate=rs1("holydate") then %>
<script language="javascript">
alert("start date cannot start on public holiday")
</script>
<%elseif enddate=rs1("holydate") then %>
<script language="javascript">
alert("end date cannot end on public holiday")
</script>
<% end if%>

but it cant work.i got try to loop the recordseet fromthe table public holiday and then match it also no response.
can u all teach me on this?
sql or codiing?
thanx

I dont use JS like this, personaly I would do this type of thing on the server side. Anyhow, I supose you can do what you are trying to do

You should research the following two functions:

isDate - (Returns a Boolean value indicating whether an expression can be converted to a date.)

cDate - (Returns an expression that has been converted to a Variant of subtype Date.)

Run these functions on the variables you are comparing to the date type value from the DB. EG:

if cDate(startdate)=cDate(rs1("holydate")) then

if you think you should use a function, use it. To ensure varaibles are the type you want them to be, wrap functions around them.

FYI - you say:
;;;but it cant work.
You should be more precise, what are the exact browser behaviours, errors etc

Wind is your friend
Matt

hi mat41, thanx again.i have solve it.
thank you very much.