Yes, that is how i got the code i have above. Both formats throw errors.
What is your data source? I believe that the date calculation will likely be done at the data source level so if "01/01/2013" is not a valid format at the source, you might get an error. What are the specific errors?
Oddly enough, the date works after i extract the data and connect to the extract. it wouldn't work off the original source, which in the end doesn't matter since i will be using an extract.
Thank you for the assistance. the article you referenced really does have everything needed in case anyone else has this problem
You are seeing inconsistency because the extract can handle dates in format 01/01/2013, but your original source apparently can't. The article suggests using hyphens (rather than slashes), as this seems to work more consistently across databases.