Date comparison flow designer

levino
Giga Guru

Hi there

I have a catalog item with a DateTime variable.

 

i have also created  custom action 

(function execute(inputs, outputs) {
// ... code ...
  var currentdate = gs.nowDateTime();
   outputs.result = currentdate;
})(inputs, output

when i compare the 2 dates i get this error using the If condition in flow designer

if 'result' is at or after the ' catalog item datatime variable)''

Flow Designer: Operation(LucidChart.If$1.evalConditions) failed with error: com.snc.process_flow.exception.OpException: unable to evaluate condition for /if/_0_2394934e1b75a510e4a8cbb9274bcb96 = 27/03/2023 21:32:05 was not a datetime in format (ParseCaseSensitive(false)(Value(Year,4,10,EXCEEDS_PAD)'-'Value(MonthOfYear,2)'-'Value(DayOfMonth,2))'T'(Value(HourOfDay,2)':'Value(MinuteOfHour,2)[':'Value(SecondOfMinute,2)[Fraction(NanoOfSecond,0,9,DecimalPoint)]]))[Offset(+HH:MM:ss,'Z')['['ParseCaseSensitive(true)ZoneRegionId()']']]

1 ACCEPTED SOLUTION

Change script as below.

 

(function execute(inputs, outputs) {
var accStartDate=inputs.RequiredDate;
var currentDate=new GlideDate();
//gs.log('accStartDate'+accStartDate);
//gs.log('currentDate'+currentDate);
// var compareDate=accStartDate.compareTo(currentDate);
// gs.log('compareDate'+compareDate);
if(accStartDate<=currentDate){
outputs.result=true;
}else{
outputs.result=false;
}
})(inputs, outputs);

 

 

View solution in original post

22 REPLIES 22

Thanks Gopi, is the below validation ok

 

get this error

{
"Action Status": {
"code": 1,
"message": "Error: syntax error (Process Automation.76f563121b352dd0bb2dbaeccc4bcbc9; line 17)"
}
}

levino_0-1679978843937.png

 

Please share complete screenshot of you action.

 

 

levino_1-1679979537761.png

 

Missing } after 15th line. 

levino
Giga Guru
{
    "Action Status": {
        "code": 1,
        "message": "Invalid return type encountered"
    }
}