I’ve spent a lot of time over the years troubleshooting issues that resulted in it being because of the date format. After a while I started to make a habit of always using dates in a numerical format when used for conditions, whether it be in Set Analysis or a Where clause.
Here are a couple examples.
Load Script
Sales:
Load
RowNo() as Id,
Num(Date) as DateNum,
*
Inline [
Date, Amt
10/8/2019, 100
10/9/2019, 125
10/10/2019, 75
11/1/2019, 150
11/10/2019, 200
];
Left Join(Sales)
Load
DateNum,
1 as FutureFlag
Resident
Sales
Where
Num(DateNum) > Num(Today());
Set Analysis

With this, you don’t have to worry about setting the correct date format.