Using Conditional Formatting to Populate a New Field Using Field Calculator.

Question

I am trying to use conditional statement to populate a new field using the Field Calculator.  I have a column named "Days from Appt."  I would like the field to populate if less than 7 days "One week or less."  I named this new column Duration.  Can someone please help a newbie to programming with this?  Can either  be in VB or Python. Thanks.

BillFearrington · Answer

Thanks for your help.  I'll have to give it a try on Monday.  Wish Me Luck.  🙂

DanPatterson_Retired · Answer

the !your_field_here!

for homework...

if a < 7:

val = do blah

elif (a >= 7) and (a < 14):

val = more blah

...

else:

val = final blah

return val

​

BillFearrington · Answer

Also I tried this before I left for the day.  I would put the code in the code block and what would I use

for the box under the code block?