We are using the date in the Billing Rule, Invoice settings, Line Description formula. We are using [PmTran.Date] and it give me the MM/DD/YYYY HH:MM:SS AM. Is there a way to format this with just the date?
Answer
Fomatting a date in a billing rule
Best answer by Laura03
Hello,
What options have you tried?
I have two ideas that may work - CDate and Left functions.
= CDate([PmTran.Date])
=LEFT([PmTran.Date],8)
Laura
Michael Coman
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.