(datediff("n",{?Start Date},dateadd("n",330,{PROBSUMMARYM1.DOWNTIME_END}))

[Former Member]

Hi Experts,

I have formula as below.

(datediff("n",{?Start Date},dateadd("n",330,{PROBSUMMARYM1.DOWNTIME_END}))

{?Start Date} is prompt that need to be filled manually while running the report.

Now i need to automate this report, so i need to avoid the prompt by setting {?Start Date} value automatically.

i need to set the {?Start Date} value as (currentdate), but while doing so am getting value only as date part like 25/10/2014.

but i want the value as 25/10/2014 00:00:00.

In other words in the above formula {?Start Date} should be replaced with currentdates start time(00:00:00)

Please help me.

Thanks.

[abhilash_kumar]

Hi Ajay,

Try this please:

(datediff("n",cdatetime(current date&time(0,0,0)),dateadd("n",330,{PROBSUMMARYM1.DOWNTIME_END}))

-Abhilash

[abhilash_kumar]

I'm sorry, the code should be:

(datediff("n",cdatetime(currentdate,time(0,0,0)),dateadd("n",330,{PROBSUMMARYM1.DOWNTIME_END}))

-Abhilash