Date formatting in a text merge field
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
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 & "."