Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

monthtodate

Status
Not open for further replies.

menark

IS-IT--Management
Jul 15, 2004
13
US
Is there a problem with the functions monthtoday, yeartodate, Lastyearytd ????
in Crystal 9.2.0.448

I am evaluating a simple date field and it meets the requirements but it keeps giving me 0 for the end results..???
 
if {invoice_hdr.invoice_date} in MonthToDate then
{invoice_line.extended_price} else 0

the thing is if I use the below formula it works.. so I would need to modify my formulas for (MonthToDate, YearToDate, LastYearYTD)

if {invoice_hdr.invoice_date} >= '05/01/2005' then
{invoice_line.extended_price} else 0
 
Was this fixed when you checked your Set Print Time value?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top