In a cast was not an entity type issue with date

Like (0) Share

Report

Posted on 30 May 2022 11:45:41 by Regash

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).

All responses (2)

Answers (0)

Regash 10 on 31 May 2022 at 09:05:59

Like (1)

Report

Re: In a cast was not an entity type issue with date

Thanks for your reply, I have tried your way but it is still the same error
RobElliott 10,166 Super User 2025 Season 2 on 30 May 2022 at 12:45:21

Like (0)

Report

Re: In a cast was not an entity type issue with date

@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.