on 06-06-2014 10:05 PM
Hello Gurus,
I am a newbie in BO and working on a requirement. I have the following syntax which works fine if we need range of dates. But I need just one date prompt and not two. How can I fix following syntax which gives me only one prompt for date.
@Select(Details\GMT) >=
CAST( @Prompt('Select Date','D',,Mono,Free) AS TIMESTAMP(0))
+ CAST ((SELECT HR_DIFF FROM GSC.PERMT_DAYLIGHTS WHERE @Prompt('Select Date','D',,Mono,Free) BETWEEN GSC.PERMT_DAYLIGHTS.STRT_TSP AND GSC.PERMT_DAYLIGHTS.END_TSP) AS INTERVAL HOUR)
Regards
@Select(Details\GMT) >=
CAST( @Prompt('Select Date','D',,Mono,Free) AS TIMESTAMP(0))
+ CAST ((SELECT HR_DIFF FROM GSC.PERMT_DAYLIGHTS WHERE @Prompt('Select Date','D',,Multi,Free) InList GSC.PERMT_DAYLIGHTS.STRT_TSP AND GSC.PERMT_DAYLIGHTS.END_TSP) AS INTERVAL HOUR)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.