Date Filter to Include Records within 3 days of Current Date

Transact-SQL
1

I have a date field in our ERP system in the format of YYYYMMDD, this is the field I want to filter off of and pull any records that have a date within 3 days of "todays" date. The ERP system stores the system date in the same format. However, in SQL the date is store in this format "YYYY-MM-DD TT:TT:TT.TTT", either way I am not sure how to organize the query but the format issue is really throwing me off.
Sample Data

+--------------+-------------------------+------------------------------------------------+-------------------------+
| SalesOrderNo | OrderDate | BilltoName | UDF_NEEDDATE |
+--------------+-------------------------+------------------------------------------------+-------------------------+
| 0011476 | 2023-09-22 00:00:00.000 | INDUSTRIAL SOLUTIONS GROUP | 2023-09-24 00:00:00.000 |
| 0011477 | 2023-09-25 00:00:00.000 | INDUSTRIAL SOLUTIONS GROUP | 2023-09-29 00:00:00.000 |
| 0011486 | 2023-09-26 00:00:00.000 | COMMERCIAL & INDUSTRIAL DIVING CO | 2023-10-06 00:00:00.000 |
| 0011490 | 2023-09-26 00:00:00.000 | CASH - GULF LAND STRUCTURES | 2023-09-26 00:00:00.000 |
| 0011491 | 2023-09-26 00:00:00.000 | CASH - REDEEMING GRACE GLOBAL METHODIST CHURCH | 2023-10-02 00:00:00.000 |
| 0011492 | 2023-09-26 00:00:00.000 | QUALITY PRODUCTION MANAGEMENT | 2023-09-27 00:00:00.000 |
| 0011497 | 2023-09-26 00:00:00.000 | SOUTHERN FORCE HEATING & COOL | 2023-10-05 00:00:00.000 |
| 0011499 | 2023-09-26 00:00:00.000 | ABBEVILLE FIRE DEPARTMENT | 2023-09-26 00:00:00.000 |
| 0011500 | 2023-09-26 00:00:00.000 | CASH- PHI | 2023-09-29 00:00:00.000 |
+--------------+-------------------------+------------------------------------------------+-------------------------+

OutPutDesired

+--------------+-------------------------+-------------------------------+-------------------------+
| SalesOrderNo | OrderDate | BilltoName | UDF_NEEDDATE |
+--------------+-------------------------+-------------------------------+-------------------------+
| 0011477 | 2023-09-25 00:00:00.000 | INDUSTRIAL SOLUTIONS GROUP | 2023-09-29 00:00:00.000 |
| 0011490 | 2023-09-26 00:00:00.000 | CASH - GULF LAND STRUCTURES | 2023-09-26 00:00:00.000 |
| 0011492 | 2023-09-26 00:00:00.000 | QUALITY PRODUCTION MANAGEMENT | 2023-09-27 00:00:00.000 |
| 0011499 | 2023-09-26 00:00:00.000 | ABBEVILLE FIRE DEPARTMENT | 2023-09-26 00:00:00.000 |
| 0011500 | 2023-09-26 00:00:00.000 | CASH- PHI | 2023-09-29 00:00:00.000 |
+--------------+-------------------------+-------------------------------+-------------------------+

This is what I've tried;

SELECT 
"dbo"."SO_SalesOrderHeader"."BillToName" AS "BillToName", "dbo"."SO_SalesOrderHeader"."OrderDate" AS "OrderDate", "dbo"."SO_SalesOrderHeader"."SalesOrderNo" AS "SalesOrderNo", "dbo"."SO_SalesOrderHeader"."UDF_NEEDDATE" AS "UDF_NEEDDATE", "
 FROM 
"dbo"."SO_SalesOrderHeader" 
 WHERE "dbo"."SO_SalesOrderHeader"."UDF_NEEDDATE"  = '{%Current Date YYYY/MM/DD%}-3'
2

I was able to get something working with this code.

WHERE        (dbo.SO_SalesOrderHeader.UDF_NEEDDATE BETWEEN { fn CURDATE() } AND DATEADD(DAY, 4, { fn CURDATE() }))