Yesterday

[2006 IR Open Discussion]

By: Ruben Misrahi - rnmisrahi

Yesterday

2003-05-19 11:30

Is there a way to write yesterday's date in a report?

I mean as a parameter. As far as I know, new Date() will print today's date.

 

Would it be the same using TimeStamp?

 

Thanks

 

 

 

 

By: Gregory A. Swarthout - gswarthout

RE: Yesterday

2003-05-19 11:55

How about new Date(System.currentTimeMillis() - 24 * 60 * 60 * 1000)

 

 

 

 

By: Albert L. - looks

RE: Yesterday

2003-05-19 11:57

try this :

 

java.util.Date yesterday =

new java.util.Date( System.currentTimeMillis() -

86400000 );

 

 

 

 

 

By: Ruben Misrahi - rnmisrahi

RE: Yesterday

2003-05-20 07:43

Thanks much!

A further need was to get the day before a certain Timestamp stored in a field. Using your ideas I found the solution to that too:

new java.sql.Timestamp($F{DTE}.getTime()-86400000)

 

Thanks again!