parameter (date) from searchpage to result page

[peterhanse]

I have a tabular report with search page . In the search page, I send a parameter with a start date on which I seek ( [ @beginyear ] ) to the resulting page .

In the Calculated Field in the resultpage i like to have:

 

search date ( [ @ beginning year ] = 1-1-2016

Record: Start date item item [ @field : begin_date_item ] = 5-5-2016

result: Calculated Field = 5-5-2016 [@field: begin_date_item ]

Or

Record: Start date item item [@field: begin_date_item ] = 12-4-2015

result: Calculted Field = 1-1-2016 ( [ @ beginning year ]

 

Unfortunately, this does not works. It seems that the parameter of the search page is not working with the proper date format , somebody ideas

CASE

WHEN
[@field:begin_date_item]<[@beginyear]

THEN

[@beginyear]
                                      
ELSE

[@field:begin_date_item]

END                                     

[MayMusic]

I am not sure how you are passing this parameter, it should be either through a link in this format: http://URL?beginyear=1/1/2016

or on advanced tab of the search page you checked to pass [@ beginyear ]

 

either way the code should be working in this format:

CASE

WHEN
'[@field:begin_date_item]'<'[@beginyear]'

THEN

'[@beginyear]'
                                      
ELSE

'[@field:begin_date_item]'

END    

Make sure to select [@field:begin_date_item] from picker and also make sure parameter name is spelled correctly

[peterhanse]

It's strange when i test whit Datediff everything works correct, so the parameters are correct.

[MayMusic]

Check the format of the date in the table and see if the parameter value is also in the same format!!!!

[peterhanse]

I have chance the localization to english (us) so all date are now the same and format are al the same, is it possible that there is  a issue that the  the date from the tabels and from the popup calendar not the same notation have . Because when i have my app localization on Dutch. the date's are different.  

But that now solved for the time being with chance the localization to english (us).

The scrip is still not working, despite the fact that the parameters are now well , and the date is the same note

[peterhanse]

I have workt it around whit:

CASE

WHEN
(Datediff(Day,'[@field:begin_date_item]','[@beginyear]')) < 0

THEN
'[@field:begin_date_item]'

ELSE
'[@beginyear]'

END

 

[MayMusic]

Thanks for sharing