AnsweredAssumed Answered

Calendar Calc Field

Question asked by chinook on Jan 21, 2009
Latest reply on Jan 22, 2009 by chinook

Title

Calendar Calc Field

Post

Calendar Template Table

31 records

 

RecordID - Number - Indexed - Auto enter, Serial

gBaseDate Date - global

ShowDate - Calculation - gBaseDate-Day (gBaseDate) + RecordID

WithinSameMonth - Calculation - Case(Month(gBaseDate) = Month ( ShowDate ); RecordID)

 

I want to modify the calc in field WithinSameMonth so that if I pick a date in BaseDate is before the 15 of the month it puts in the RecordID value and if I pick a date that is after the 15 it put in  RecordID, otherwise no value is entered. I tried the following calc but it does not seem to work:

 

 

Case ( RecordID ≥ 15 and Month ( gBaseDate ) = Month ( ShownDate ); RecordID; RecordID ≤ 15 and Month ( gBaseDate ) = Month ( ShownDate ); RecordID; "" )<!--  POLLS  --><!--  FILES  --><!--  SIGNATURE  -->

Outcomes