Hi All,
if the Data is matached with below two dates i have to tag Yes other than date i have to tag No.
Please help me which funchtion do i need to use
3/21/2023 9:24:00 AM
3/21/2023 1:31:00 PM
Date | Expected Output |
3/21/2023 1:30:00 PM | Yes |
3/21/2023 1:31:00 PM | Yes |
3/21/2023 10:00:00 PM | No |
3/21/2023 11:36:00 PM | No |
3/21/2023 11:37:00 PM | No |
3/21/2023 2:00:00 AM | Yes |
3/21/2023 2:51:00 AM | Yes |
3/21/2023 2:52:00 AM | Yes |
3/21/2023 3:00:00 PM | Yes |
3/21/2023 5:46:00 AM | Yes |
3/21/2023 6:00:00 AM | Yes |
3/21/2023 6:01:00 AM | Yes |
3/21/2023 6:27:00 AM | Yes |
3/21/2023 6:36:00 AM | Yes |
3/21/2023 8:46:00 AM | Yes |
3/21/2023 8:48:00 AM | Yes |
3/21/2023 9:24:00 AM | No |
3/21/2023 9:39:00 AM | No |
Thanks & Regards,
Niranjan
Hey @NiranjanK1, can you provide some clarification here please? You have 'Yes' next to some records that a) don't match your two target dates and, b) don't sit between them or anything either. What's the exact logic here? Thanks!
@DataNath if data is lesster than two dates i have to exclude from the flow.
@NiranjanK1 really still not following:
3/21/2023 3:00:00 PM | Yes |
Is later than both datetimes and is marked as 'Yes'
3/21/2023 10:00:00 PM |
No |
Is later than both datetimes and is marked as 'No'
3/21/2023 1:30:00 PM | Yes |
Is between both datetimes and is marked as 'Yes'
3/21/2023 9:39:00 AM | No |
Is between both datetimes and is marked as 'No'
From your logic that being earlier than the two datetimes, several of the labels don't make sense. Can you shed some more light on this or expand on the logic?
@DataNath i have provided two dates, In data lesster than that two dates i want to tag "Yes". Becuase those dates i wan to exclude from the flow.