Creating a date condition
Creating a date condition
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 (79.59 KiB) Viewed 3220 times
-
- Posts: 6344
- Joined: Tue Mar 20, 2018 5:34 am
Re: Creating a date condition
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.
Sorry, maybe we did not exactly understand your question. Could you explain your issue in more detail, which issue do you have?
Thank you.
Re: Creating a date condition
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.
-
- Posts: 6344
- Joined: Tue Mar 20, 2018 5:34 am
Re: Creating a date condition
Hello,
You can compare DisplayDateComplete with Today.AddYears(-1)
Thank you.
You can compare DisplayDateComplete with Today.AddYears(-1)
Thank you.
Re: Creating a date condition
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.
-
- Posts: 6344
- Joined: Tue Mar 20, 2018 5:34 am
Re: Creating a date condition
Hello,
You can use the following expression:
DisplayDateComplete == Today.AddYears(-1)
Thank you.
You can use the following expression:
DisplayDateComplete == Today.AddYears(-1)
Thank you.
Re: Creating a date condition
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.
-
- Posts: 6344
- Joined: Tue Mar 20, 2018 5:34 am
Re: Creating a date condition
Hello,
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.