Extracting date from string and passing it in subreport 1

[crystaldev1]

Hello, I'm using CR 11 and Sql Server 2008. I have a formula that saves a user parameter which is how this application saves user parameter. I need to extract a date field from this string and pass it into a subreport to use the same date range. This string will look like this:

<|> 05/31/2011 05:00 PM Local (GMT-8)

I just need to extract the date field and pass it in the subreport to select the date range. Thanks.

 

[lbass]

Is the field in the subreport a date datatype? If so, create a formula like this and use it as a link to the subreport date field:

date(split({@string}," ")[2])

You can go into the subreport selection formula (report->selection formula->record) and adjust the resulting formula as necessary.

-LB

 

[crystaldev1]

This is perfect except that the string does not contain space between > and 05. So the string is "<|>05/31/2011 05:00 PM Local". Should I just use the Right function to extract the 10 characters?

 

[lbass]

date(mid({@string},4,10))

-LB

 

[crystaldev1]

That'll work too. Thanks.

 

[crystaldev1]

How would I extract everything after the last ">"?

For example, I would like to extract AB123 from this string. But this value can be any number of characters:


<|>05/31/2011 05:00 PM Local(GMT-8)<|>AB123


Thanks.

 

[lbass]

stringvar array y := split({table.field},"<|>");
y[ubound]

-LB