Setting Date Time in parameter Field

[Former Member]

I use the date parameters. I also include the time too. But I wanted to make the Time to a default option like 0:0:00 and I think now generally it takes the System as default. How do I change it

[Former Member]

Hi

Once you click on callender it will also show you the current system time you need to make the values as zero's (0). This will take zeros in your paramter time stamp.

Thanks,

Sastry

[Former Member]

But for the next time when I refresh my report it doesnt take the same thing. It again takes the Current time

[abhilash_kumar]

Hi,

This is 'By design' and the only way you can set a timestamp to 00:00:00 is to set a default value for the datetime parameter.

Right-click the parameter and select Edit > In the Value Options set 'Default Value' to 00:00:00.

This will show 00:00:00 in the timestamp and it will also set the date to a deafult value I guess it 12/30/1899.

Hope this helps!

-Abhilash

[Former Member]

Thanks that worked say for the end date I want to make it equal to current system date how do I do that

[abhilash_kumar]

Well, if it is a date range parameter and if you set a default value then it applies to both - start date and end date.

If you would like the end date to have current system time, then create another parameter just for the end date without setting a default value.

-Abhilash

[Former Member]

I want to set the date parameters such that

The start date should be First day of the previous month and the end date should be the last date of the previous month

How do I do that