How to add no.of days to Date!!

[Former Member]

Hi Guys,

Please can any one tell me how to add 7 days to the current date !!

Regards

Thanks

San

[Former Member · Accepted solution]

Hi.

For this requeriment you need to make an UDF.

for example you can use this.

import java.util.Date;

import java.util.Calendar;

Calendar today = Calendar.getInstance();
today.setTime("yourdate"); 
today.add(Calendar.DATE, 7);

return today.getTime();

[Former Member · Accepted solution]

Wow very quick, but what is the source, yourdate?? what format please??

Thanks

Regards

San

Edited by: ASandhya on Aug 26, 2010 9:40 AM

[Former Member · Accepted solution]

Hi.

Remove this section

today.setTime("yourdate");

return today.getTime().toString();

[Former Member · Accepted solution]

Not working Luis....

[Former Member · Accepted solution]

Hi ASandhya .

Use this .

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
String strdate = "";

Calendar today = Calendar.getInstance();
today.add(Calendar.DATE, 7);
strdate = sdf.format(today.getTime());

return strdate;

....Did you put the class on import section?.

java.util.Date;java.util.Calendar;java.text.SimpleDateFormat;

Edited by: Luis Ortiz on Aug 26, 2010 12:02 PM

[Former Member · Accepted solution]

Hi Luiz,

I have imported those classes, what you have mentioned. It is throwing "system error". My input is today, with string format??

if I am wrong please correct me !!

Regards

San

[Former Member · Accepted solution]

Well for this UDF I don't use any input.

Calendar today = Calendar.getInstance();

Only I take the current system date so It won't have a problem.. for my side it works.

What is your exactly error¿

[Former Member · Accepted solution]

Hi Luiz,

I should agree, it works for current date. Any way problem resolved.

Points alloted

Many Thanks

San

[GabrielSagaya]

function myudf(Container container)

{

String today;

try {

String dt = "2010-01-01"; // Start date

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");

today=sdf.format(calendar.getTime());

Calendar c = Calendar.getInstance();

c.setTime(sdf.parse(today));

c.add(Calendar.DATE, 7); // number of days to add

today = sdf.format(c.getTime()); // dt is now the new date

} catch (Exception e) {

e.printStackTrace();

}

return today;

}

[Former Member]

Not working Gabriel ...