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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
currentdate / current month problem ?!
It works now: Local NumberVar jahr := Year(currentdate); Select Month(currentdate) Case 12: If cdate(Tonumber(Left({S510.SPMON},4)),Tonumber(Right({S510.SPMON},2)),1) In Date(jahr,1,1) To Date(jahr,12,31) Then {S511.UMKZWI3}-{S511.GUKZWI3} Else 0 Default: If...- CayJack
- Post #5
- Forum: Business Objects: Crystal Reports 1 Formulas
-
currentdate / current month problem ?!
So, that's what I did with the Formula: if ToNumber(Right({S510.SPMON},2)) = month(currentdate) AND ToNumber(Left({S510.SPMON},4)) = year(currentdate) then {S510.ZUMKZWI3} else 0 It works fine. So I tried to change the following formula as well since I am not using the Date-Field...- CayJack
- Post #4
- Forum: Business Objects: Crystal Reports 1 Formulas
-
currentdate / current month problem ?!
Thanks Skip.... I was thinking way to complicated. Left and Right works perfect... didn't even think about that way. Thanks a lot.- CayJack
- Post #3
- Forum: Business Objects: Crystal Reports 1 Formulas
-
currentdate / current month problem ?!
Hi there, I have a table S511 with a date (day, month, year) and another table S510 with a monthly date (month, year) When I work with table S511 (D,M,Y) I can use the following formula without any issues: if (month({S510.SPTAG}) = month(currentdate)) AND (year({S510.SPTAG}) =...- CayJack
- Thread
- Replies: 4
- Forum: Business Objects: Crystal Reports 1 Formulas
