Can a prompt value be concatenated in Universe

[Anu1284]

Hi,

My requirement is the user will be prompted for a year and based on the year, I need to concatenate it to the last date of the year (i.e., "12/31/" + prompt year) and fetch the corresponding record.

Can you please suggest a way to get this done.

Thanks,
Anu.

 

[skrandel]

What's your database?

You should be able to do this by using a combination of concatenation and conversion from character to date.

It all depends on your database platform.

Steve Krandel
Knightsbridge Solutions
formerly BASE Consulting Group

http://www.knightsbridge.com

 

[skrandel]

DB2. I'll think about it.

Steve Krandel
Knightsbridge Solutions
formerly BASE Consulting Group

http://www.knightsbridge.com

 

[Sridharan]

Yes you can. Like Steve said it depends on your DB. If you are on Oracle you would do something like this..

TO_DATE('12/31/' || @Prompt('Enter Year','N',,Mono,Free),'MM/DD/YYYY')

If you are on DB2 then blom is the person.

Sri

 

[Anu1284]

The Database is DB2. When I include the filter condition as

1. table.field(date) <= date(@prompt('Enter the Report Year','A',,MONO,FREE) || '12-31').

I get the error as &quot;An unexcepted token <end of statement> is found following &quot;'&quot;.

I changed it to the following:

2. table.field(date) <= date(@prompt('Enter the Report Year','A',,MONO,FREE) + '12-31').
I get the same error message.

Any suggestions on this.

 

[Sridharan]

Why have you mentioned table.field(date)?? Shouldn't that be just table columnname. Is that how you specify in DB2. Anyway you have missed a - after the year. Maybe that could be the cause. Try this one

table.field(date) <= date(@prompt('Enter the Report Year','A',,MONO,FREE) || '-12-31').

Sri