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

Question

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

AJ 0

Hi,

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

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.

TIA

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

AnnuKumari-MSFT 34,561 Reputation points Microsoft Employee Moderator

2023-11-28T06:53:51.64+00:00

AJ ,

Just following up to see if the below answer helped. Please do consider clicking Accept Answer as accepted answers help community as well. Also, please click on Yes for the survey 'Was the answer helpful'

1 answer

Your answer

AnnuKumari-MSFT 34,561 Reputation points Microsoft Employee Moderator

2023-11-28T06:53:51.64+00:00

AJ ,

Just following up to see if the below answer helped. Please do consider clicking Accept Answer as accepted answers help community as well. Also, please click on Yes for the survey 'Was the answer helpful'

Answer 1

Amira Bedhiafi 40,576 Volunteer Moderator

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'

Share via

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

1 answer

Your answer