Creating reports and dashboards | Stimulsoft community forum

Hello,

how do i find the difference between 2 dates using this function?

{datediff(startdate,enddate).Days}

I tried this but to no avail. what format should i set for this?

Hello.

Could you specify which components you are using? Flash or JS?

Thank you.

Hello,
I am facing the problem in DateDiff function. I am using the JS component.
This is the whole expression where I am using:
Round(((DateDiff(SessionsAttended.OUT1,SessionsAttended.IN1))/1000)/60,0) where OUT1 = '2019-01-13 04:53:00' and IN1 = '2019-01-13 04:53:00'
It is throwing an error:
Parser error: Operator '/' cannot be applied to operands of type 'TimeSpan' and type 'Decimal'
Can you help me to solve this problem?

Hello,

Please send us a sample report with test data which reproduces the issue for analysis

Thank you.

Hello,
Sorry due to security and complexity of project I won't be able to provide you with the test report.
I can clear you out what I want, I just needed the date difference of 2 DateTime fields in minutes. i.e. IN1 and OUT1 fields as mentioned in my previous post.
So is there any predefined function for that in JS component so I can work on that.
Any help will be appreciated.

Thanks

Hello,

You can sue the following expression:
{DateDiff(Variable1, Variable2).TotalMinutes}

Thank you.