Date in ARIS Script Reports

Hello Markus,

you can use the standard Date() object in javascript to achieve that:

var today = new Date() // this will give you the current system date in a Date object

today.setDate(today.getDate() - 30) // this will take 30 days off today's date

If you prefer a more precise time you can use today.getTime(), that will return the number of millisecond since 01/01/1970. I hope it helps.

Hello Markus,

if you are using Object.Attribute().getValue(), ARIS will return you a String. You cann usethat string to create a Date if you want to:

var fdateString = aObject.Attribute(XXXX, nLocal).getValue() // this will get the value of the custom attribute you created

var fdateDate = new Date(fdateString) // this will create a  Date object from the string value of the attribute

once you have your dates you can compare using standard comparisons:

var today = new Date()
var fdateDate = new Date(fdateString)
 
if (fdateDate > today) {
     // fdate is in the future
}

I hope it helps

Nice to read this, but actually i am searching to convert a date from "Nov 5, 2010 6:49:15 AM" into "05-11-2010" (dd-mm-yyyy)

How can i do this, both examples does not work:

          strtypeo = __toString(ocurrentattribute.Type());

          strvalue = __toString(__toString(ocurrentattribute.GetValue(true)));

          if (strtypeo == "Time of generation") {

            formatter = new SimpleDateFormat("dd-mm-yyyy");

              strgenerationm = formatter.format(strvalue);      

           }

or

          strtypeo = __toString(ocurrentattribute.Type());

          strvalue = __toString(__toString(ocurrentattribute.GetValue(true)));

          if (strtypeo == "Time of generation") {

            strgenerationm = dateFormat(strvalue,"dd-mm-yyyy");

           }

Hi all,

There shouldn't be any access limitations for these packages - just use the fully-qualified class name as shown below.

Regards

Marc

var now = new Date();

var formatter = new java.text.SimpleDateFormat('dd-mm-yyyy');

var result = formatter.format(now);

Hi all,

You can use "new java.util.Date()" or simply "new Date()" to create the date object and can see the methods that can be used

http://download.oracle.com/javase/1.5.0/docs/api/java/util/Date.html

Just some things to remember

1. If you use it in Reports, then the date returned is server date. Using it in Macro returns your local system date.

2. The month returned by Date.getMonth() method is 1 month less, as the index starts from 0. Same while creating date object, the number provided for month should be -1 the actual month number. Try these with some small test script.

Comparing Date :-

For comparing dates, string compare is not a good option, and it may include a lot of comparing logic also. The best way to comapare the date, or to subtract some no of days, or to find out the difference of dates, is to convert both the dates to milliseconds and do the comparision. Date.getTime() method can give the milliseconds.

@Markus, comparing the date might be wrong if both the dates are in different GMT string. 30 days milliseconds can be found out by 30*24*60*60*1000

So your steps should be

1. Read the date stored in attribute as string.

2. Create a Date object from that string. Find out the milliseconds.

3. Get the system date. Find out the milliseconds.

4. Find out difference in Milliseconds.

5. Find out days, Days = (((((Difference in Milliseconds)/1000)/60)/60)/24). You can use Math.round(), Math.floor() or Math.ceil() methods to round the number if required.

Now you can compare the Days with 30 or any other value.

Thanks,

Amol Patil

Thanks,

I have found the solution (use MM to see the month, mm to see minutes!) :

  strvalue = __toString(__toString(ocurrentattribute.GetValue(true)));
if (strtypeo == "Time of generation") {
    strdate = new Date(strvalue);
    formatter = new java.text.SimpleDateFormat("dd-MM-yyyy");
    strdate = new Date(strvalue);
    strgenerationm = formatter.format(strdate);
}