Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
azure data flow: filter by last modified date doesn't seem to be working with source
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 38%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
javier cohenar
211
Reputation points
Hi, I'm trying to filter the files consumed by a Source operation in Azure Data Flow using the "Filter by last modified" box using an expression formula.
This is the original "Filter by last modified" box:
This is the formula:
And when I click to save the expression formula, I always get this fixed value:
The expected result should be the expression formula instead of this fixed value '2023-06-20'
Am i missing something?
Azure Data Factory
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 12%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Subashri Vasudevan 11,226 Reputation points2023-06-21T15:22:47.7766667+00:00 Hello Javier, I was able to replicate your issue.
It seems to be a bug. But will let MSFT champs confirm this.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 38%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EQ%3C/text%3E%3C/svg%3E)
QuantumCache 20,366 Reputation points Moderator2023-06-21T16:25:58.1466667+00:00 Thanks Subashri,
We are verifying on this!
-
QuantumCache 20,366 Reputation points Moderator
2023-06-21T18:13:26.8733333+00:00 Hello @javier cohenar, Thanks for reaching out on this forum.
Try providing TimeStamp , a date alone will not work!
Please try adding timeStamp to your Filter criteria!!!!
Please let us know if that helps!addDays(currentTimestamp(),-10)If we choose from the calendar, then it will show the timestamp as well.
If i miss the timestamp then the error message is displayed!
-
javier cohenar 211 Reputation points
2023-06-21T18:23:09.67+00:00 thanks but addDays(currentTimestamp(),-10) doesn't work neither. same result
-
QuantumCache 20,366 Reputation points Moderator
2023-06-21T18:40:11.24+00:00 Hello @javier cohenar
Are you not able to see the Expression taken? could you please clear the filed and reload the browser to re-try?
Please add screenshot of the issue here?
-
javier cohenar 211 Reputation points
2023-06-21T19:27:28.9833333+00:00 thanks, i confirm to you that i cannot see the expression being taken
I have already reloaded the browser and switched to Chrome and back to Edge also. Screenshots of the issue are still exactly the same as those shared on the original post
-
QuantumCache 20,366 Reputation points Moderator
2023-06-21T20:14:00.8766667+00:00 Thanks for the confirmation.
For a deeper investigation and immediate assistance on this issue, if you have a support plan you may file a support ticket, else please let me know if you need more help on creating technical support ticket!
Sign in to comment
Sign in to answer