I have 2 fields. One is Need Date and the other is Need Date Adjusted. What code would I use to have it display the date with an "A" before it in the same field if it was adjusted and just the date if it wasn't.Thanks for any help, I'm very new to this.
Are these two fields are date-format? If so keep the format because it's easier to manipulate the values if you need to later. You can't have more than one data format in a record content. I suggest you create another boolean field next to it and call it "adjustedDate". Flag it true or yes if the datefield was adjusted or false or no otherwise.
TO display in Crystal report with prefix, you can create a formula and call it AdjustedDate and use the following argument
Another way you can do as quickly is to insert a text object and type A: and insert it infront of your datefield, then
right click on the text object and select format text, then click on the icon opposite the suppress and write the condition to suppress it when not adjusted. This way you can still format your date field to remove the time portion. It should work faster than having formulas manipulated by crystal before displaying.