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?
Solved
Fomatting a date in a billing rule
Best answer by Laura02
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
1 person likes this
+19Hello,
What options have you tried?
I have two ideas that may work - CDate and Left functions.
= CDate([PmTran.Date])
=LEFT([PmTran.Date],8)
Laura
Laura ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.