Hello,
I have an issue with my flow, I am trying to get all the data that the date is equal to today and I am using the below method, but when I run my flow this error shows up (The child type 'date' in a cast was not an entity type. Casts can only be performed on entity types. inner exception: The child type 'date' in a cast was not an entity type).
although my date format is the same in the flow and my excel sheet (yyyy-MM-dd).
Thanks for your reply, I have tried your way but it is still the same error
@Regash you need to put your expression inside single quotes, and make sure you select ISO 8601 for the DateTimeFormat field otherwise it uses Excel's native dates which are stored as integers.
Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.