I need to get yesterday's date and have it in mmddyyyy format. I am very new at this. Please help. Thank you. I am using GetDate but the format returns m/d/yyyy and i don't want to change regional settings. Also if you know how to perform a replace function, that would be great. Thanks again