Hey everyone,

Here is my deal:

I'm unable to input dates as a parameter in any format other than yyyy-mm-dd.

My company uses a CR viewer that only allows users to input dates in mm-dd-yyyy format.

So for a workaround, I've changed the date parameter to a string parameter and am attempting to then edit that string into a date for my selection criteria.

The problem I'm running into is this error when trying to input the formula:

Error:
"Too many arguments have been given to this function."

Formula:
CDate ((right({?TestStartDateString}, 4)) , (left({?TestStartDateString}, 2)) , (mid({?TestStartDateString}, 4, 2)))


Is there a better function to use, or maybe just a small error I am making? All I'm trying to do at this point is drop these values (mm, dd, yyyy) into a date variable, then I should be able to figure out the rest. Much appreciation for your time!


Edited by little wing - 09 Feb 2012 at 10:01am

This did the trick, Thank you KostYa! I had tried it with a - instead of a , but had no luck, funny this would work. Much appreciated!