Dave Stone
asked on
Crystal Reports - Date Field Font Color
Hello,
I have a report that shows me inventory transactions. I have 2 dates that I am looking at. One being when the product went into inventory and the other is when I shipped the product. I have the date field for when it went into inventory use a red font if this date is less than the ship date. This works fine. However, I would like the date that it went into inventory to be a red font only if it went into inventory 6 months before the ship date. How would I do that? This would help me see the product that sits in inventory for 6 months before being shipped.
Thank you
I have a report that shows me inventory transactions. I have 2 dates that I am looking at. One being when the product went into inventory and the other is when I shipped the product. I have the date field for when it went into inventory use a red font if this date is less than the ship date. This works fine. However, I would like the date that it went into inventory to be a red font only if it went into inventory 6 months before the ship date. How would I do that? This would help me see the product that sits in inventory for 6 months before being shipped.
Thank you
ASKER
Perfect, can I also make it bold using the same criteria?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Awesome. Thank you.
Open in new window
orOpen in new window