Creating a date condition

Stimulsoft Reports.WEB discussion
Post Reply
ARathje
Posts: 4
Joined: Tue Apr 27, 2021 2:01 pm

Creating a date condition

Post by ARathje »

I am trying to create a condition on my report (E2 Shoptech reporting) that shows the date in the history as highlighted if has been over a year since the last completion. I believe that it is a c# reporting system. I am attaching screen shots of the condition and the report data's location. I appreciate any help you can provide as our customer is requesting an inspection if this qualification is met and we have hundreds of part that we provide to them.
Attachments
Date Complete location.jpg
Date Complete location.jpg (79.59 KiB) Viewed 3032 times
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Creating a date condition

Post by Lech Kulikowski »

Hello,

Sorry, maybe we did not exactly understand your question. Could you explain your issue in more detail, which issue do you have?

Thank you.
ARathje
Posts: 4
Joined: Tue Apr 27, 2021 2:01 pm

Re: Creating a date condition

Post by ARathje »

I am trying to have a condition on our report to highlight the last date sold if it is over 1 year per the DisplayDateComplete data. I see it as: highlight the last date processed if the date is today minus 1 year.
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Creating a date condition

Post by Lech Kulikowski »

Hello,

You can compare DisplayDateComplete with Today.AddYears(-1)

Thank you.
ARathje
Posts: 4
Joined: Tue Apr 27, 2021 2:01 pm

Re: Creating a date condition

Post by ARathje »

How do I create that comparison? Using an expression? I apologize, I am not very well versed in how to design components in a report.
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Creating a date condition

Post by Lech Kulikowski »

Hello,

You can use the following expression:
DisplayDateComplete == Today.AddYears(-1)

Thank you.
ARathje
Posts: 4
Joined: Tue Apr 27, 2021 2:01 pm

Re: Creating a date condition

Post by ARathje »

Using that expression it comes up with an error that DisplayDateComplete does not exist in the current context. I don't even understand what that means.
Lech Kulikowski
Posts: 6197
Joined: Tue Mar 20, 2018 5:34 am

Re: Creating a date condition

Post by Lech Kulikowski »

Hello,

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

Thank you.
Post Reply