Report with condition between two Date/Time fields.

[Manik Arora3]

Hi,

I have a requirement where I need to create a report and check if value in one date field is less than the value in other date.

Example:

There are two tables: rm_story and rm_sprint.

In the example below, I need to get the report for the condition "Stories Completed Date/Time"(This is a field in rm_story table) is less than 'Planned End date'(It is referenced from rm_story table's field 'Sprint')

This condition does not give any result. Please help.

[ben_knight]

It looks like your condition logic is a bit confused. You are looking at Less than 0 Hours before which means you are actually looking for records that have an end date after the completed date. You may want after or set it to more than.

[Onkar Pandav]

Hi,

That condition you wrote won't work because your requirement is different.

I believe your requirement is to check if first field value is less than second. So you need to first calculate the difference using script and then write a condition in report.

Let me know if it helps.