All of the INT values are 0. I spot checked, and many should be 1 or 2, because the dates are within the condition boundaries listed. I imported the dataset from excel, and that file has ORDERING_DATE in mm/dd/yyyy format. The code in the picture is someone else's code that I'm taking over, I think he must've converted the excel values for that variable into for example 03MAR2021 format. So that his code is as pictured. I am not planning to convert the excel file into 03MAR2021 format. But this code pictured does not read it correctly. If I can write something that can make it read mm/dd/yyyy, that'd solve the problem.
... View more