• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

date comparison

 
prakash muthu
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I stuck with date comparison. The user will enter a date in browser (HTML file). I suppose to check with a date available in Access database. The problem is, date is stored with time in access and what ever i typed is in string format.
so if you have any idea about the comparison, let me know
TIA
with regards
Prakash
(praksahem@rediffmail.com)
 
Peter Tran
Bartender
Posts: 783
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Prakash,
Take a look at http://www.javaworld.com/javaworld/jw-12-2000/jw-1229-dates.html
I hope the article can give you some ideals.
Good luck,
-Peter
Okay...I took out the period at the end of the URL. Try it now.
[This message has been edited by Peter Tran (edited January 03, 2001).]
 
Ipsita Naravane
Greenhorn
Posts: 29
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Peter,
I was not able to go to that link.
Prakash, I think you can convert the date to Timestamp and then compare it with the date in the database.
Shilpa
 
Peter Tran
Bartender
Posts: 783
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
http://www.javaworld.com/javaworld/jw-12-2000/jw-1229-dates.html
Try the link now. If it still gives you a problem, try making sure you don't have a period at the end of URL.
 
prakash muthu
Ranch Hand
Posts: 75
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Peter and Shilpa,
thanks for your mail. I already have the article from Java world. But i couldn't get any points from there. I'll try to convert to timestamp and let you know peoples.
with regards
Prakash
(prakashem@rediffmail.com)
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic