I am trying to display a field which combines an order-number and an order date. That is easy enough, using a formula to combine them. However the problem is that, before combining them, I want to change the date (which is in DATE-TIME format) to just date (i.e. mm/dd/yy). After changing it, I want to combine the date-only field with the order number for the report field. i have been trying all kinds of things with no luck.
Your help is appreciated!!