Liveware Publishing Support Forum

Hi,__I am trying to average on only the top 20 date fields in the database . How can I do that.____Thanks__Daisy

I have a field "Re" and the data inside this field is dates. What I want to do is subtract the current date from the "RE" filed __Thanks for the help.____Daisy____

thanks that problem got solved there is one more little problem could you help me solve this. I have a field "Re" and the data inside this field is dates. What I want to do is that subtract the current date from the "RE"____Thanks for the help.____Daisy

Hi,____I am trying to use average in report writer but the values are incorrect for examples I want the of data in Month field of the data base in sql I would do AVG(MONTH) but I cannot do that here could some please guide me in the right direction.____Thanks__Daisy