Date comparison flow designer

levino · ‎03-27-2023

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()']']]

Gopi Naik1 · ‎03-28-2023

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);

If my solutions helps you to resolve the issue, Please accept solution and Hit "Helpful".

Thanks,
Gopi

View solution in original post

levino · ‎03-27-2023

Thanks Gopi, is the below validation ok

get this error

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

Gopi Naik1 · ‎03-27-2023

Please share complete screenshot of you action.

If my solutions helps you to resolve the issue, Please accept solution and Hit "Helpful".

Thanks,
Gopi

levino · ‎03-27-2023

Gopi Naik1 · ‎03-27-2023

Missing } after 15th line.

If my solutions helps you to resolve the issue, Please accept solution and Hit "Helpful".

Thanks,
Gopi

levino · ‎03-27-2023

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