I am using two date fields for holding Beginning and Ending date values for checking against a range. I have another date field that contains the current date (using 'Now' in the field settings). I determine the beginning date based on this current date with a behavior. I.e. if the current date is past the 15th then use the first day of the next month. Works great except for the fact that I have to manually change the current date field for the first day in beginning date for this to work. E.g. Today is 10/01/2009, when entering a date to check against this date - all dates past 10/01/2009 are accepted but not 10/01/2009. If I manually edit the current date even by simply deleting the 0 before the 1 (i.e. 10/1/2009) and run the behavior then 10/01/2009 is accepted. I have tried to program the current date to equal the system date but same problem - I must manually change the date before that date is accepted in the criteria.
Any ideas on this?
