• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

What class to use for date-related calculations.

 
Anton Golovin
Ranch Hand
Posts: 527
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I need to disregard records more than 48 hours removed. So what would you advise I use: Date or Calendar?
 
mike acre
Ranch Hand
Posts: 197
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Date is lighter & faster (by a huge amount) and simpler for Mr JP and there is no need for Calendar.

You can get a Date from the database format using SimpleDateFormat, then you can subtract 48hrs from it and compare it with the current date.
 
peter wooster
Ranch Hand
Posts: 1033
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by mike acre:
Date is lighter & faster (by a huge amount) and simpler for Mr JP and there is no need for Calendar.

You can get a Date from the database format using SimpleDateFormat, then you can subtract 48hrs from it and compare it with the current date.


Beware of the use of Date and attempts to determine today's date from it. The value is stored in UTC (GMT) and as such if you aren't in England or its summer, your value for midnight isn't the same as Date's. The easiest way around this is to use the SimpleDateFormat to convert midnight this morning to a Date and then use that in calculations.
 
Anton Golovin
Ranch Hand
Posts: 527
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Here's the method... I bet there is an easier way...


[ September 07, 2004: Message edited by: Anton Golovin ]
 
peter wooster
Ranch Hand
Posts: 1033
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Anton Golovin:
Here's the method... I bet there is an easier way...

Here's what I do, I only allow today, tomorrow and the day after.

It calsulates minDate as midnight this morning, then calculates the max date as 2 days later. Since all values are at midnight, time == 0, this will work. Here's the Functions methods:
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic