Based on Time how to tag Output Yes or No

Question

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

DateExpected Output3/21/2023 1:30:00 PMYes3/21/2023 1:31:00 PMYes3/21/2023 10:00:00 PMNo3/21/2023 11:36:00 PMNo3/21/2023 11:37:00 PMNo3/21/2023 2:00:00 AMYes3/21/2023 2:51:00 AMYes3/21/2023 2:52:00 AMYes3/21/2023 3:00:00 PMYes3/21/2023 5:46:00 AMYes3/21/2023 6:00:00 AMYes3/21/2023 6:01:00 AMYes3/21/2023 6:27:00 AMYes3/21/2023 6:36:00 AMYes3/21/2023 8:46:00 AMYes3/21/2023 8:48:00 AMYes3/21/2023 9:24:00 AMNo3/21/2023 9:39:00 AMNo

Thanks & Regards,
Niranjan

NiranjanK1 · Answer

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

DataNath · Answer

@NiranjanK1 really still not following:

3/21/2023 3:00:00 PMYes

Is later than both datetimes and is marked as 'Yes'

3/21/2023 10:00:00 PMNo

Is later than both datetimes and is marked as 'No'

3/21/2023 1:30:00 PMYes

Is between both datetimes and is marked as 'Yes'

3/21/2023 9:39:00 AMNo

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?

NiranjanK1 · Answer

@DataNath if data is lesster than two dates i have to exclude from the flow.