topic WFA - MVEL Function to get current date in Active IQ Unified Manager Discussions

WFA - MVEL Function to get current date

CLAYTONJS — Tue, 10 Mar 2015 14:47:21 GMT

Has anybody been able to create an MVEL function to get the current date? Or is this even possible?

I was hoping to use this so that when I called the function it would return a date in a format i.e. ddMMMyyyy. I've been reading up and have been trying different things, but have had no luck what so ever.

Any help is appreciated.

Cheers,

Clayton

Re: WFA - MVEL Function to get current date

trentino123 — Tue, 10 Mar 2015 15:02:56 GMT

Hi Clayton,

Try a new function with this MVEL code :

def Timestamp(hello) {

import java.util.Date;

d=new Date();

return d;

}

During the test call it with Timestamp(1) , so it is not empty in the inputs, the number 1 is not used.

Hope it helps.

Thanks!

Re: WFA - MVEL Function to get current date

sinhaa — Tue, 10 Mar 2015 16:17:50 GMT

Good solution terentino. As an alternative which completely gives date in format ddMMyyyy is the below function.

====

def GetDate(hello) {
import java.util.*;
import java.text.SimpleDateFormat;

return new SimpleDateFormat("ddMMyyyy").format(Calendar.getInstance().getTime());
}

====

Call it the same way like GetDate(1).

sinhaa

Re: WFA - MVEL Function to get current date

Adai — Tue, 10 Mar 2015 16:24:43 GMT

Hi Clayton,

I got this from one of the community contributors, bestinj.

def getDate(data)
{
java.util.Calendar cal= java.util.Calendar.getInstance(java.util.Locale.getDefault()) ;
java.text.SimpleDateFormat format = new java.text.SimpleDateFormat("HH-mm-MM-dd-yy");
return format.format(cal.getTime());
}

Call the function as getDate(1)

Thanks to bestinj for the help

You can play with the SimpleDateFormat("HH-mm-MM-dd-yy") for different date formats.

Hope this helps.

Regards

adai

Re: WFA - MVEL Function to get current date

CLAYTONJS — Tue, 10 Mar 2015 17:15:50 GMT

That is perfect guys. Thank you very much. You have made my life much easier and my WFA workflows a lot cleaner.

Cheers,

Clayton

Re: WFA - MVEL Function to get current date

Siegfried — Wed, 09 Sep 2015 16:06:24 GMT

Above solutiuons caused a syntax error on my system, so I created this one :

def getDate(dateFormat) {

// dateFormat - string for SimpleDateFormat

import java.text.SimpleDateFormat;
import java.util.Date;
Date curDate = new Date();
SimpleDateFormat format = new SimpleDateFormat(dateFormat);
String DateToStr = format.format(curDate);
return (DateToStr);
}

You call it : getDate('yyyy_MM_dd')