combining formulas 1

[patty1]

The second formula brings down what I want, but I need the formatting part that is in the first formula. No matter what I try I get "too many arguments..." or "summary field could not be created". Any ideas?

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



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

Thanks

 

[rosemaryl]

Dear Patty1,

Why do you have the Date() in your formula. If this is a date field, you don't need that.

To the second formula you posted add:

Week Ending: " & totext(Maximum ({Transaction_History.Post_Date}, {Transaction_History.Post_Date}, "weekly&quot,"MM/dd/yyyy&quot

I have tested this formula and assuming that you do have data grouped this way in the report, it works.

ro
Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[LV]

"Week Ending: " + totext(cdate(maximum({Time.DateWorked}, {Time.DateWorked}, "weekly&quot))

Does this work?

 

[patty1]

Thanks ro - I had date in there because I had the below formula in another report and it had worked so I thought I needed it in order to date format. Well, live and learn - thanks again

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

 

[patty1]

LV - Actually ro was right - I did not need date but what is the c for in cdate?

 

[LV]

Equivalent to Date function, except it can be used in both Crystal and Basic syntaxes, while Date can be used in Crystal only.