I am working on a project and during data preparation process, I need to create a variable based on other variable. In data set, source variable is Hour and values stored under this field as 11012013 (MMDDYYYY) but this is stored as number. Now I want to populate weekday from this variable Hour. Is there any function to perform this? Can you please help me?