Isolating Part of a Date Field
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=23054
Printed Date: 02 Apr 2025 at 2:34am
Topic: Isolating Part of a Date Field
Posted By: bjfils
Subject: Isolating Part of a Date Field
Date Posted: 30 Sep 2024 at 4:22am
I have a need to compare values in a table, but only report on those where a part of the data is a mismatch. The data in the field in question would be in the format of 010-4XXXX-8XX. This is for properly recording the general ledger account number for invoices. I'm only interested in instances when the 8 in this field isn't the same in all line items for each invoice number. There will be cases where some of the entries for the invoice have an 8 there and other entries for the same invoice will have a 6 there. The rest of the digits in the field are irrelevant. I only need to report on those where there's a 6 and an 8. All sixes or all eights are correct. There will be at least two, and maybe more, line items in the table. The constant in the table is the invoice number.
No clue how to query for this. Any suggestions? Thanks,
|
|