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

    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.