Separating the data and time field into two parts to create a prompt 1

[Enea]

I have one field which has date and time.

Users will have to open a few reports where they need to indicate a From/To date without time and other reports where they only need to indicate From/To time.

Right now I when I drag the field into the conditions panel I don't have a way to indicate only date or indicate only time.

How can I obtain what I need?

 

[blom0344]

I guess you are working with ORACLE?
Have a look at functions like TRUNC/ROUND/TO_CHAR/TO_DATE.
These will give you possibility to build proper universe objects / prompts ..

Ties Blom

 

[Enea]

db: sql server
I will look into what you suggested.
Thank you

 

[blom0344]

Then have a look at the special SQL server convert() function..

Ties Blom