Date range and Vlookup Approximate Match Equivilant

Question

Hello,

I am having an issue with making an equivalent to the VLOOKUP approximate match in Alteryx.

Formula example: =VLOOKUP(B2,Calendar!A:C,3,TRUE)

B2 = Assigned Date = 8/14/2025

I need it to join the tables together so that I can return the check date of 8/29/2025 dynamically.

BeginsEndsCheck DateWK #7/12/20257/25/202508/01/25317/26/20258/8/202508/15/25338/9/20258/22/202508/29/25358/23/20259/5/202509/12/2537

I assume there is a formula I just can't wrap my head around it, and I don't know how to join the two data sets together without an exact match on the joins.

Peter_Guirguis · Answer

Hey @Skyline_TnL  - one way to attempt this is try the formula tool using a "Between" function. 
results -1 means True and 0 means False.

Yoshiro_Fujimori · Answer

Hi @Skyline_TnL ,

I would APPEND the [Assigned Date] with the date range table and filter with the [Begins] and [Ends] fields as below;

Multi Field Formula

This is to convert the dates to Date Type.

DateTimeParse([_CurrentField_],"%m/%d/%Y")

Filter

[Assigned Date] >= [Begins] AND 
[Assigned Date] <= [Ends]

Workflow

Output

Assigned DateBeginsEndsCheck DateWK #2025-08-142025-08-092025-08-222025-08-2935

I hope this helps. Good luck.

Skyline_TnL_20251126.yxmd