?
Solved

problem with dates

Posted on 2001-06-18
7
Medium Priority
?
169 Views
Last Modified: 2013-12-18
hello experts,
  i put textbox and change the field properties as datetime.when i run this in notes client its working fine.the same when i run this on web calender type is not coming.i dont want to user should select the dates from the control not by typying manually. and one more thing is i want to calculate difference in dates.if it is greater than 21 days it should give message that diff should be less than 21 days.how to do this.is there any inbuilt control is there.


waiting for answer.
0
Comment
Question by:shaikhidayat
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 4

Expert Comment

by:sloeber
ID: 6201384
Shaikidayat,

You can't use the popup calendar screen on the web.
If you want to use a popup calendar tool for selecting dates, you must write it down in Java.


About the time difference.
Do you want the formula for calculating the difference or do you want the formula for the popup or both ?
When must it check the dates, on the moment the user enter a date or every day?
Do you have on your form two date fields, or do you have one time field and the other time field is today.

For showing a message screen on the web you use alert("text")

Greets,
Sloeber

0
 
LVL 4

Expert Comment

by:sloeber
ID: 6201660
This is the formula for calculating the days
<body>

<form name=exf1>
D1 <input name=d1 type=text value="01">
M1 <input name=m1 type=text value="01">
Y1 <input name=y1 type=text value="2000">
<BR>
D2 <input name=d2 type=text value="03">
M2 <input name=m2 type=text value="05">
Y2 <input name=y2 type=text value="2000">
<BR>
Delta Days <input type=text name=delta value="<?>">
<BR>
Business Days <input type=text name=bizdelta value="<?>">
<BR>
<input type=button onclick="compute()" value="compute!">
</form>
<script type=text/javascript>
function compute() {
  var date1 = new Date();
      date1.setYear  (document.exf1.y1.value);
       date1.setMonth (document.exf1.m1.value);
       date1.setDate  (document.exf1.d1.value);
  var date2 = new Date();
      date2.setYear  (document.exf1.y2.value);
       date2.setMonth (document.exf1.m2.value);
       date2.setDate  (document.exf1.d2.value);
  var delta = date1.getTime() - date2.getTime();
      delta = delta / ( 1000 * 60 * 60 * 24 ); // units are now days.
      if (delta < 0) delta = -delta;
       delta = Math.round(delta);
       
         
  document.exf1.delta.value = delta;
     if (delta > 21) alert("Data difference should be less then 21 days")
         

}
</script>


0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 4

Accepted Solution

by:
sloeber earned 120 total points
ID: 6201665
This is the formula for calculating the days
<body>

<form name=exf1>
D1 <input name=d1 type=text value="01">
M1 <input name=m1 type=text value="01">
Y1 <input name=y1 type=text value="2000">
<BR>
D2 <input name=d2 type=text value="03">
M2 <input name=m2 type=text value="05">
Y2 <input name=y2 type=text value="2000">
<BR>
Delta Days <input type=text name=delta value="<?>">
<BR>
Business Days <input type=text name=bizdelta value="<?>">
<BR>
<input type=button onclick="compute()" value="compute!">
</form>
<script type=text/javascript>
function compute() {
  var date1 = new Date();
      date1.setYear  (document.exf1.y1.value);
       date1.setMonth (document.exf1.m1.value);
       date1.setDate  (document.exf1.d1.value);
  var date2 = new Date();
      date2.setYear  (document.exf1.y2.value);
       date2.setMonth (document.exf1.m2.value);
       date2.setDate  (document.exf1.d2.value);
  var delta = date1.getTime() - date2.getTime();
      delta = delta / ( 1000 * 60 * 60 * 24 ); // units are now days.
      if (delta < 0) delta = -delta;
       delta = Math.round(delta);
       
         
  document.exf1.delta.value = delta;
     if (delta > 21) alert("Data difference should be less then 21 days")
         

}
</script>


0
 

Author Comment

by:shaikhidayat
ID: 6201832
hai  sloeber,
   thanks for sending me very fast reply.one of solutions what u send is working means the datepicker control is working fine on the web.
  the other to calculate the differnce i cut the code and put one
button  onclick  javascript

i paste the code.but i am getting syntax error the curson is at <body> .

so what i have to do.

i want to calculate the difference between the two date fields  from which i select from the datepick code.
i think u might have understand my problem.

0
 
LVL 8

Expert Comment

by:Jean Marie Geeraerts
ID: 6205462
Hello,
Put the following JavaScript code in the onSubmit event of your form :

  var date1 = new Date();
  date1.setYear(document.forms[0].year1.value);
  date1.setMonth(document.forms[0].month1.value);
  date1.setDate(document.forms[0].day1.value);

  var date2 = new Date();
  date2.setYear(document.forms[0].year2.value);
  date2.setMonth(document.forms[0].month2.value);
  date2.setDate(document.forms[0].day2.value);
 
  var delta = date1.getTime() - date2.getTime();
  delta = delta / ( 1000 * 60 * 60 * 24 ); // units are now days.
  if (delta < 0) delta = -delta;
  delta = Math.round(delta);
  if (delta > 21)
    {
     alert("Difference is more than 21 days!");
     return false;
    }
  else
     return true;

This code supposes the following :
On your form you have seperate fields for day, month and year to enter the dates :
Date 1 is build from year1, month1 and day1 fields.
Date 2 is build from year2, month2 and day2 fields.
If the check fails an error message is displayed and the form is not submited. If the check is OK, the form is submitted.

If you have your dates in one field, you need to substract the seperate parts of the date from that field using the substring method in JavaScript.
If you need help with this, I can give you the code, but you need to specify how dates are entered in your form. (dd/mm/yyyy or mm/dd/yyyy or any other way?)
0
 
LVL 1

Expert Comment

by:anuu
ID: 6215054
Hi,

Regarding the error,
it appears as though it is an error due to js or the HTML used... Include all js functions that you would like to use in the <Head> tag.

anu
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses
Course of the Month10 days, 18 hours left to enroll

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question