AnsweredAssumed Answered

Calculating day of the week from date field using field calculator

Question asked by payvandr on Jul 9, 2014
Latest reply on Jul 9, 2014 by Christian_Wells-esristaff

I have a date field that I need to extract what day of the week the date is.  The process I used before was simply creating a new field inputting the following in the field caculator:

 

Pre-logic vba script code:

 

dim dow_val as integer

dow_val = datepart ("w", [DATE_])

 

Day=

dow_val

 

 

 

where "Date_" is obviously my date field and "Day" is the new field I created. This used to work for me all the time but now it returns an error every time, can anyone help me out? Running arc 9.3. Thanks in advance.

Outcomes