AnsweredAssumed Answered

If/Case date problem

Question asked by C.AllenCrawford on Dec 13, 2012
Latest reply on Dec 14, 2012 by philmodjunk

Title

If/Case date problem

Post

     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.

     If(Date<1/1/2013;Amount;0)

     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.

FMScreenShot.JPG

Outcomes