Converting number to date

[SergeS]

Hi all,

I am prompting a user to enter a year, f.e. 2002 (specified as number I guess).

After that I want to select data from the database using something like: is valid on 31/12/entered year in this example 31/12/2002.

How can I transform the entered year to the date 31/12/entered year?

Thanks in advance,

Serge

 

[blom0344]

Hello Serge,

sounds like the ever reappearing demand for: 'dependant' or 'cascading' prompts you are after.
Look at the whole of thread:


thread393-335185 T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com

 

[SergeS]

Thanks blom,

however I found the following solution:

I created an object in my universe stating: convert(datetime, '12/31/' + @Prompt('Enter reference year','A',,MONO,FREE)) (I am using Sybase Adaptive Server)

when I need to compare dates I can use the @Select(object) in my condition.

Cheers, Serge