Field Calculation - if statement (vbscript)

eXoScoriae — Tue, 16 Mar 2021 18:11:44 GMT

I was trying to do something I thought would be fairly simply. I need to sort a bunch of dates into quarters. I started by created a new field with just the month of the dates. So, it is numbers 1 through 12 in a field that is defined as a string [Quarter]
I then created a blank strong field called Qtr. The idea is, to check the value in [Quarter] and assign either Q1, Q2, Q3, or Q4 to [Qty]

here is the code:
Pre-Logic Script Codeblock

Dim val
If [Quarter] = "1" then
val = "Q1"
else if [Quarter] = "2" Then
val ="Q1"
else if [Quarter] = "3" Then
val ="Q1"
else if [Quarter] = "4" Then
val ="Q2"
else if [Quarter] = "5" Then
val ="Q2"
else if [Quarter] = "6" Then
val ="Q2"
else if [Quarter] = "7" Then
val ="Q3"
else if [Quarter] = "8" Then
val ="Q3"
else if [Quarter] = "9" Then
val ="Q3"
else if [Quarter] = "10" Then
val ="Q4"
else if [Quarter] = "11" Then
val ="Q4"
else if [Quarter] = "12" Then
val ="Q4"
else
val = ""
end if

Code block
Qtr =

val

Seems really simply and straight forward. I've found plenty of other threads with similar if statements that seemed to work for the folks using them.

The geoprocessor window is spitting out generic errors.
General error executing calculator
ERROR 999999: Error executing function
Expected 'If'
Failed to execute (CaluclateField)

Re: Field Calculation - if statement (vbscript)

DavidPike — Tue, 16 Mar 2021 18:26:27 GMT

is it not elseif rather than else if

Re: Field Calculation - if statement (vbscript)

eXoScoriae — Tue, 16 Mar 2021 18:30:46 GMT

thank you

topic Field Calculation - if statement (vbscript) in Geoprocessing Questions

Field Calculation - if statement (vbscript)

Re: Field Calculation - if statement (vbscript)

Re: Field Calculation - if statement (vbscript)