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.
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());
With this, you don’t have to worry about setting the correct date format.