If/Case date problem
Old dog trying to learn new software. This is too simple but can't seem to figure out why it is not working. I am simply trying to post a field with existing data if it meets 3 criteria but I can't even get one test to work.
When I enter a date 12/12/2012 and amount, the result in the new field gives me 0 and it should give me the amount? (The field does require a 4-digit date but it should convert properly anyway)
All I am trying to do is post a field for 2012Pledges on an ongoing basis as money is received.
If(Date>12/31/2011 and Date<1/1/2013 and Type="Pledge";Amount;0)
I am expecting that the field 2012Pledges would be updated with the posted amount.
I am probably going to have to learn how to set a field etc but if I can't even perform a simple IF test this is going to be harder than I thought. Any help getting me started would be appreciated.