nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Python how to compare Date Fields in MakeFeatureLayer

JoseSanchez

Hello everyone,

I exported a ModelBuilder to Python where there is a FeatureLayer where I compare 2 Date Fields and it works fine in Model Builder but in Python it displays the following error message:

ExecuteError: ERROR 000230: Failed selecting with MODDATE <> MODDATE_1 \n\n

Failed to execute (MakeFeatureLayer).

This is the python code:

# Process: Make Feature Layer (5)

arcpy.MakeFeatureLayer_management(Agreement, Agreement_Layer1, "MODDATE <> MODDATE_1 \\n\\n", "", "OBJECTID OBJECTID .... ")

Find more posts tagged with

Accepted answers

RandyBurton

Have you tried it without the new line codes (\n\n) ?

"MODDATE <> MODDATE_1"

All comments

JoseSanchez

Thank you all!! Removing the \n\n" fixed the problem.

XanderBakker

And if you remove the " \n\n", does it work? The \n refers to additional <Enter> you entered in the expression.

The alternative is to run the tool manually and copy the Python snippet from the Results window:

Using the Results window—Help | ArcGIS for Desktop

RandyBurton

Have you tried it without the new line codes (\n\n) ?

"MODDATE <> MODDATE_1"

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.