Clarion, What am I doing wrong?

What am I doing wrong?

Author	Message
Mike RENAL #1 / 5	What am I doing wrong? Clarion 5.5B2 Legacy templates I needed to work out the first day of a previous 28 day 'month' this could looks good to me, but gives the wrong answer, not even on a 28 day boundary point! GLO:LastMonth = CON:BaseDate + ((TODAY() - CON:BaseDate) / 28 - 1) * 28 This code works fine, Month# = ((TODAY() - CON:BaseDate) / 28 - 1) GLO:LastMonth = CON:BaseDate + 28 * MONTH# It looks like the same code to me, what can I not see starring me in the face? Somebody tell me please! Regards Mike Renals
Mon, 25 Nov 2002 03:00:00 GMT

Brett C. Camma #2 / 5	What am I doing wrong? Quote: > GLO:LastMonth = CON:BaseDate + ((TODAY() - CON:BaseDate) / 28 - 1) * 28 >This code works fine, > Month# = ((TODAY() - CON:BaseDate) / 28 - 1) > GLO:LastMonth = CON:BaseDate + 28 * MONTH# Con:BaseDate plus month# multiplied by 28 isn't quite the same as Con:BaseDate plus 28 multiplied by month#, is it? Also, in the first example, your month calc inside the parentheses resolves to an intermediate floating point value whereas in your second example you are resolving it to an integer. This will also allow for the possibility of dissimilar results. Regards, Brett C. Cammack
Mon, 25 Nov 2002 03:00:00 GMT

Mike RENAL #3 / 5	What am I doing wrong? Thanks for the comments, but I disagree, Quote: >> GLO:LastMonth = CON:BaseDate + ((TODAY() - CON:BaseDate) / 28 - 1) * 28 >>This code works fine, >> Month# = ((TODAY() - CON:BaseDate) / 28 - 1) >> GLO:LastMonth = CON:BaseDate + 28 * MONTH# >Con:BaseDate plus month# multiplied by 28 isn't quite the same as >Con:BaseDate plus 28 multiplied by month#, is it? Yes it is, the order is irrelevant, maths operators are done in a strict hierarchy, (power and %, then * and / and finally + and - ). Quote: >Also, in the first example, your month calc inside the parentheses >resolves to an intermediate floating point value whereas in your >second example you are resolving it to an integer. This will also >allow for the possibility of dissimilar results. In my desperation I did try GLO:LastMonth = CON:BaseDate + (INT((TODAY() - CON:BaseDate) / 28) - 1) * 28 and it made no difference. Quote: >Regards, >Brett C. Cammack
Mon, 25 Nov 2002 03:00:00 GMT

Maarte #4 / 5	What am I doing wrong? Mike, the outcome of ((TODAY() - CON:BaseDate) / 28 - 1) will be a real. Assigning it to Month# will truncate this to a long Your difference will be: ( ((TODAY() - CON:BaseDate) / 28 - 1) - Month# ) * 28 (the fractional part times 28) -- Best regards, Maarten C5EEb - ABC & C5.5b2 Certainly Clarion Developer
Tue, 26 Nov 2002 03:00:00 GMT

Brett C. Camma #5 / 5	What am I doing wrong? Quote: >Thanks for the comments, but I disagree, >Yes it is, the order is irrelevant, maths operators are done in a strict >hierarchy, (power and %, then * and / and finally + and - ). >In my desperation I did try > GLO:LastMonth = CON:BaseDate + (INT((TODAY() - CON:BaseDate) / 28) - 1) * 28 >and it made no difference. Humor me... Try: GLO:LastMonth = CON:BaseDate + 28 * (INT((TODAY() - CON:BaseDate) / 28) - 1) Regards, Brett C. Cammack
Tue, 26 Nov 2002 03:00:00 GMT

Page 1 of 1

[ 5 post ]