Search results for query: *

Hi, Could someone help me with modifying this formula. if {message_stats.msg_transmission_date} >= DATEADD ("m", -12, CURRENTDATE-day(currentdate))+1 and {message_stats.msg_transmission_date} < maximum(lastfullmonth) + 1 then {message_stats.msg_premium} This returns a value if the date is...

Thanks. I've removed the }, the date field is also substituted, it's now refering to this part and saying a date is needed dateadd("yyyy",-1, currentdate); Any thoughts?

Hi, I know I'm missing something basic with this: datevar x := dateadd("yyyy",-1, currentdate});{table.date} in dateadd("m",-1,x-day(x)+1) to x-day(x) but I keep gettin gthe error that the ")" is missing, where's it missing from? Any Ideas?

Hi, I was wondering if someone could help. I need to have a formula that gives results for the last full month, but for last year. So if i were to run the report today 18th May 2010 it would return results for All April 2009. Thanks All

Thanks for this explanation. I really appreciate it. I understand now what its doing.

Thanks for this, it does exactly what I need it to. Can you help me one stage further and explain what the formula is actually doing? Thanks again.

HI, I'm new to crystal and Tek-tips so any help would be really aprreciated. I need to create a formula/paramter using a date field for a rolling 12 months but for whole months only. So, if I run the report today, 9th December, it will only report on dates that are 30th November 2009 back to...