Force date to 06:00am

building reports webintelligence
1

Hi all,

I need to prompt date which should force to 06:00:00am start date for what ever date we enter and end at 06:00:00am end date.
Any idea folks how to do that.

thanks in advance! :smiley:

Praveen8367 (BOB member since 2010-11-27)

2

Just create two prompts; date & time. the time prompt should be forced 6 am to 6 am (so the user has no choice) and one date prompt where the user must enter a date.

katullus :us: (BOB member since 2009-08-21)

3

I can do that for one time but i want it for all the time user enter any date.

Praveen8367 (BOB member since 2010-11-27)

4

Take your prompt value and concatenate it with the time that you want

Condition:

DATE_COLUMN = to_date(@Prompt() || ‘06:00:00’, format_string)

define this condition in universe.

jprasanthram :switzerland: (BOB member since 2010-12-10)

5

Prasanthram
thanks for your reply.
will try that.

Praveen8367 (BOB member since 2010-11-27)