Liveware Publishing Support Forum

I solved the problem.. I flipped around the comparrison, and now it works.

**Correction to previous posting**____In the very last part of my previous posting, I said I was receiving an error message "Invalid Argument". That is incorrect. What^s happening is that when I set Period1=FiscDec04, it^s suppose to print out "December", but it is actually print...

There are 12 date fields: FiscJan04, FiscFeb04, etc.____There are 3 period fields: Period1, Period2, Period3____These are all calculation fields. FiscJan04 contains the date range for our fiscal January month, FiscFeb04 contains the date range for our fiscal February Month, etc.____In order to get t...

Fiscxxx04 is returning data for a particular date range.____So.. if I make calculation field "Period_1" equal to calculation field "FiscJan04" and then I make Period_1 = True, the report will print sales figures for the month of January.____I^m trying to setup an IIF statement (i...

Unfortunately, putting quotes around Fiscxxx04 did not work. I got the invalid argument error. Fiscxxx04 is also a calculation that contains an expression consiting of a date range. That might make a difference.

I^m having a problem where the IIF statement doesn^t seem to be working correctly. When I setup my calculation fields like below, and then run the report, MonthP1 is returning "Jan" instead of "Oct". I^ve tried setting Period_1 to different expressions (FiscSep04, FiscNov04, Fisc...

When I try entering the function as:____INRANGE(post_date{1/1/2004},{1/29/2004})____I still receive the error message :Invalid Argument

Can the inlist function work with dates? If so, how do you enter?____This is how I was doing it, and I was getting an invalid argument error message:____INLIST(post_date,01/01/2004,01/29/2004)____post_date is a field in the database.____I^m I entering it wrong? Or does this function just not work wi...

I know it is possible to have the report count the number of days between two dates BUT can it also exclude Saturdays and Sundays? (so that it only counts weekdays)?____Thanks

I^m trying to design a report that prints 3 columns:__Each column will who the same type of data but(Customer Invoice ID^s and Invoice Amounts), but from different time periods:____Column A = Column B = Column C = __October Data September Data August Data______Is it possible to do this?______Thanks