HARD CODE TIME IN DATE PARAMETER

[jobillborf]

Hi, using version 9, oracle data base.

I am using two date time parameters.
{?START DATE} and {?END DATE}

I would like the user to input the dates only and hardocode the times as follows.
{?START DATE} TIME 00,00,01 AND {?END DATE} AS TIME 23,59,59

The current select statement is below


{CUSTPROB.PROBDTTM} in {?START DATE} to {?END DATE}

Thank you for your help

 

[lbass]

Why not just set up the parameters as dates isntead of datetimes? It would achieve the same thing.

-LB

 

[jobillborf]

Thank you I will try this out. If possible could you show me how to perform this in a formula.

Sincerely

jobillborf

 

[lbass]

This doesn't require a formula. You would just go into the parameter set up screen and change the datatype from datetime to date.

-LB