adding text to a formula 1

[patty1]

Can anyone tell me what the correct syntax would be for the below formula. Am getting "string needed here" and the cursor goes to the begining of Maximum. Have tried all I know.


"Week Ending: " + Maximum ({Transaction_History.Post_Date}, {Transaction_History.Post_Date}, "weekly&quot

Thanks for any help

 

[LV]

Try this:
"Week Ending: " + totext(Maximum ({Transaction_History.Post_Date}, {Transaction_History.Post_Date}, "weekly&quot)

 

[patty1]

Thanks, that works great. Would you know how I can incorporate the formatting I use in the below formula into the formula you just gave me? I keep getting "too many arguments".


"Week Ending: " + totext(date(Transaction_History.Post_Date}), "MM/dd/yyyy&quot + " " + "Sub Total"

 

[LV]

Would this work:
"Week Ending: " + totext(cdate({Transaction_History.Post_Date}))+ " " + "Sub Total"