Split using Date as a condition not working in mapping data flow

AJ 0 Reputation points


I am running a data flow that separates the incoming data based on when the record was created. However, split condition does not give any true results when using date as a filter

User's image

User's image

The data in the column placement_startdate is valid and is in date format, being sourced from mysql

User's image

I tried switching from split condition to filter condition and still it doesn't work. I am at a loss what could be causing this.


tagging SatishBoddu-MSFT @KranthiPakala-MSFT @PRADEEPCHEEKATLA-MSFT

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,472 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Amira Bedhiafi 8,631 Reputation points

    You might be correct. If the placement_startdate column in your Azure Data Factory data flow is already in a date format, you might not need to use toDate for your comparison. The toDate function typically converts a string or a numeric type to a date type. If placement_startdate is already a date, this conversion would be redundant and could potentially cause issues.

    Instead, try using the condition directly like this:

    placement_startdate >= '2023-08-01'
    0 comments No comments