If you are unable to create a new account, please email support@bspsoftware.com

 

Displaying a TEXT at the Footer based on a Date (2013-09-01) (DIM HEIRARCHY)

Started by gosoccer, 17 Feb 2014 02:47:21 PM

Previous topic - Next topic

gosoccer

Folks,

I have a requirement to display a text (not a pop up) in the bottom of the page based on
the user's calendar or manual input as BeginDate and EndDate as Feb 17, 2013 for example.

I have ParamDisplay values showing the dates as Feb 17, 2013 as well.

I have created the text inside a block and created the String Variable in Condition Explorer.
I have setup the following logic in the String Variable for 'Y' and 'N' values.

Unfortunately, it is not working and the text is now showing based on the conditions and variables assigned.
I would very much appreciate any help someone can provide.
if (ParamDisplayValue('BeginDate') < 'Feb 7, 2013') then
('Y')
else
('N')

I perhaps need some sort of date conversion to character.
:)
Thank you

Francis aka khayman

a little confused but at first glance 'Feb 7, 2013' is a string... and if compared to another string... who knows what the result is ... although you have 50% chance of getting it right since your result is just 'Y' or 'N'

use ParamValue('BeginDate'), make sure to use the date value of Feb 7, 2013 as well. if it still doesn't work, you can also try the date functions to compare between dates.