Date field in condition is ignored when a pill is used (example: Lookup Records)

Steps to Reproduce

Set system property glide.sys.date_format to "dd/MM/yyyy"
Create a flow with Lookup Record and add a condition with a date field
Put a pill in the date field
The condition will be ignored and all records will be returned


Create an action with a script step that transforms the date to the system format YYYY-MM-DD.  Pass the output of the transform to the condition.

Related Problem: PRB1331490

Seen In

London Patch 4 Hot Fix 2
SR - IRM - Audit Management - New York 2019 Q3
SR - IRM - GRC Profiles - Madrid 2019 Q2
SR - IRM - GRC Workbench - New York 2019 Q3
SR - IRM - Policy and Compliance - Madrid 2019 Q2
SR - IRM - Risk Management - New York 2019 Q3
SR - IRM - SIG Assessment Legacy - Madrid 2019 Q1
SR - IRM - Vendor Risk Management - Madrid 2019 Q1

Intended Fix Version


Safe Harbor Statement

This "Intended Fix Version" information is meant to outline ServiceNow's general product direction and should not be relied upon in making a purchasing decision. The information provided here is for information purposes only and may not be incorporated into any contract. It is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at ServiceNow's sole discretion.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2020-03-24 17:06:18