UDF for Date -7 days

[Former Member]

Hi everyone

I am fairly new to Java and PI, and I have to create a UDF that takes the currentDate and subtracts 7 days. I was just wondering the best way to go about this with java?

Thank You

[baskar_gopalakrishnan2 · Accepted solution]

UDF Code as below ..

Calendar now = Calendar.getInstance();
now.add(Calendar.DATE, -7);
String subtractSevenDays = new SimpleDateFormat("yyyy/MM/dd").format(now.getTime());
return subtractSevenDays;

// Dont forget below import statements

import java.text.SimpleDateFormat;

import java.util.Calendar;

Map it to target field.

Note: You can choose any pattern in the above SimpleDateFormat argument.

Currently the output will be ex: 2011/04/01

Edited by: Baskar Gopal on Apr 8, 2011 10:56 AM

[Former Member]

Ok Sorry I missed some of that last post, It works

Thank you everyone

[Former Member]

I still seem to be getting errors?

[Former Member]

Have a look into this blog and see case 5..

/people/sarvesh.singh3/blog/2009/02/13/yes-it-is-possible-with-datetrans-function

[Former Member]

HI,

you can use the grafical Function "current date" and "DateBefore" or "DateAfter".