AnsweredAssumed Answered

Date formatting in a text merge field

Question asked by Matty_1 on Apr 9, 2013
Latest reply on Apr 9, 2013 by Matty_1

Title

Date formatting in a text merge field

Post

     Please refer to the coding below, as you can see this is output as text.  Because I have to have this calculation in place inorder to properly display all the required information the dates are not formatted the way I want them even if I change the date settings in the merge field.  Is there and easy way around this?  I'm looking to have the date show as the following example:

     Tuesday, April 9, 2013

      

      

     Case (
      
     PaymentTerms = "Vendor Invoice Terms" ; "Payment will be issued based on the vendors invoice payment terms and will be paid via " & Lower (PaymentMethod) & "." ;
      
     PaymentTerms = "Immediately" ; "Immediate.  Payment will be issued via " & Lower (PaymentMethod) & " on " & PaymentDate & "." ; 
      
     PaymentTerms  ≠ "Vendor Invoice Terms" and "Immediately" ; PaymentTerms & " business days.  Payment will be issued via " & Lower (PaymentMethod) & " on " & PaymentDate & "." 
      
     )

Outcomes