convert string to date

0
hello: I know this has been asked but I still cannot convert any string "01/01/01" or "01/01/2001" to a date variable. I have tried new SimpleDateFormat("dd/MM/yy").parse("01/01/01") but I get a null. I am running a query that is using a date parameter but the chart comes back blank if a date is not being passed into the query, so I think. So I want to create a default date. Any suggestions? Thanks.
fwhorton's picture
Joined: Jan 29 2007 - 4:33am
Last seen: 7 years 8 months ago

1 Answer:

0
I figured it out... the field's evaluation time needs to be set to "Report". Other settings that must be noted is setting the variable's Calculation Type to "First" and reset type = "None".
Post edited by: fwhorton, at: 2007/03/22 20:33
fwhorton's picture
Joined: Jan 29 2007 - 4:33am
Last seen: 7 years 8 months ago
Feedback
randomness