Code in python the equivalent of the VB Format function

Hi Brad,

Just realized I forgot to thank you for your last post! A couple minor changes and it worked like a charm! Thanks so much for your help and explaining the rationale behind things!

Cheers,
Karl

Try this:

try:
    # Process: Add Field containing Image Date...
    gp.AddField_management(InputFC, FieldName1, "TEXT", "", "", "", "", "NULLABLE", "NON_REQUIRED", "")
    print "Added Field " + FieldName1
    gp.addmessage("Added Field " + FieldName1)

    # Process: Add Field to hold sampled value...
    gp.AddField_management(InputFC, FieldName2, "FLOAT", "", "", "", "", "NULLABLE", "NON_REQUIRED", "")
    print "Added Sample Value Field"
    gp.addmessage("Added Field " + FieldName2)
    
    # Process: Add Field to hold Raster Path...
    gp.AddField_management(InputFC, FieldName3, "TEXT", "", "", "", "", "NULLABLE", "NON_REQUIRED", "")
    print " Added Field containing Raster Path"
    gp.addmessage("Added Field " + FieldName3)    
   
    objFeatures = gp.UpdateCursor(InputFC)
    objFeature = objFeatures.Next()

    while objFeature:
        # Calculate Image Date
        # DatesInterval = +DatesInterval
        strDate = objFeature.GetValue("Date_Time")
    
        lstDate = map(int, strDate.split("/"))
        objDate = datetime.date(lstDate[2], lstDate[0], lstDate[1])
        intDay = int(objDate.strftime("%j"))
        intInterval = 0
        for i in range(1, 366, DatesInterval):
            if intDay >= i and intDay < i+DatesInterval:
                intInterval = i
                break
        objFeature.SetValue(FieldName1, str(intInterval))

        # Calculate Raster Path
        objImage = "00" + str(intInterval)
        strTif = RasterFolder + RasterPrefix + objDate.strftime("%Y") + DatePrefix + objImage[-3:] + ".tif"
        objFeature.SetValue(FieldName3, strTif)  

        objFeatures.UpdateRow(objFeature)
        objFeature = objFeatures.Next()
    del objFeature
    del objFeatures

Hi Brad,

Thanks for clearing that up. Thats sort of what I was thinking and had tried it but it didn't work, but I think thats due to another issue as its still not working. Now I get an error for

lstDate = map(int,strDate.split("/"))
ValueError: invalid literal for int() with base 10: 'DATE_TIME'

Thanks so much for your quick responses and effort on this!

Sorry, that's a careless mistake on my part. The backslashes were used an escape character for the original CalculateField code with the code block within it. In this case the backslash allows you to use a double-quote inside a string designated by double-quotes. So something like:

strString = "Field = "OBJECTID" "

doesn't work, but adding the backslash in front of the inner quotes will fix it:

strString = "Field = \"OBJECTID\" "

A better way in Python is to change the outer quotes to single quotes:

strString = 'Field = "OBJECTID" '

In your code, since these quotes are no longer encased in other double quotes, the escape character is no longer required. Change it then to:

lstDate = map(int, strDate.split("/"))  
intDay = int(objDate.strftime("%j")) 

objImage = "00" + strImageDate
strTif = RasterFolder + RasterPrefix + objDate.strftime("%Y") + DatePrefix + objImage[-3:] + ".tif"

Try that. Code is still untested so don't be surprised if other errors crop up....

Hi Brad,

Thanks for the advice and updated code. Had I known, code blocks weren't so easily transferable to python scripts I would have never bothered to redevelop that code block. Oh well lesson learned I guess. Thanks for the great advice though as it seems an update cursor would be a much more efficient solution. However, it seems the code you provided is not working correctly when I copy it over and try as I might I am unable to correct the issue. It seems to center around the use of the \ / characters in the code. Specifically, I am getting a syntax error for the line

objFeatures = gp.UpdateCursor(InputFC):

- which I think I resolved by removing the colon at the end.

The more complex errors that I am failing to understand are the backslash and forward slash characters that are giving an error message indicated an unexpected character after line continuation character within the following code lines:

lstDate = map(int, strDate.split(\"/\"))  
intDay = int(objDate.strftime(\"%j\")) 

objImage = \"00\" + strImageDate
strTif = RasterFolder + RasterPrefix + objDate.strftime(\"%Y\") + DatePrefix + objImage[-3:] + \".tif\"

The error in each line seems to occur after the first backslash in each line. I understand backslash can be line continuation characters, but I don't understand which ones I should be removing or why the code lines include these at all.

Thanks so much for all your time and effort on this. It is greatly appreciated and nice to be learning the rationale for why things are coded a certain way so I can hopefully avoid similar issues in the future. In anycase, your help is appreciated very very much! 🙂

Just was hoping you could clarify a couple more things. First in the Expression I put either Calc(!Date_Time!) or Calc(!Date_Time!,!ImgDate!) ....do I put this expression because it means the code block is calculating using values from the fields Date_Time and ImgDate?

Yes, that's exactly right. It iterates through each feature, passing the Date_Time and ImgDate value to the Calc function each time.

Do you mind showing me how to pass a python variable/argument from outside the codeblock. I've attached the entire code of python if that helps.

Once you move into a Python script, any CalculateField processes that contain code blocks should be thrown out. Code blocks are tolerable in ModelBuilder but they are a real nightmare to maintain in a script. Instead use an update cursor to manually iterate through each feature and do the every calculation you can.

I rearranged your code to add all the required fields first and then iterates through each feature using an update cursor to calculate the image date and raster path fields. The code is untested so if you run into any problems let me know.

One other thing: I'm not sure if you want the line "DatesInterval = +DatesInterval". This will continually change your DateInterval each time you pass through the loop. For example, if you're starting interval is 16, then the DateInterval for each feature will continue like so:
First feature: DateInterval = 16
Second feature: DateInterval = 32
Third feature: DateInterval = 48
etc.

I commented it out below if that's what you wanted then simply remove the comment.

try:
    # Process: Add Field containing Image Date...
    gp.AddField_management(InputFC, FieldName1, "TEXT", "", "", "", "", "NON_NULLABLE", "NON_REQUIRED", "")
    print "Added Field " + FieldName1
    gp.addmessage("Added Field " + FieldName1)

    # Process: Add Field to hold sampled value...
    gp.AddField_management(InputFC, FieldName2, "FLOAT", "", "", "", "", "NON_NULLABLE", "NON_REQUIRED", "")
    print "Added Sample Value Field"
    gp.addmessage("Added Field " + FieldName2)
    
    # Process: Add Field to hold Raster Path...
    gp.AddField_management(InputFC, FieldName3, "TEXT", "", "", "", "", "NON_NULLABLE", "NON_REQUIRED", "")
    print " Added Field containing Raster Path"
    gp.addmessage("Added Field " + FieldName3)    
   
    objFeatures = gp.UpdateCursor(InputFC):
    objFeature = objFeatures.Next()
    while objFeature:
        # Calculate Image Date
        # DatesInterval = +DatesInterval
        lstDate = map(int, strDate.split(\"/\"))
        objDate = datetime.date(lstDate[2], lstDate[0], lstDate[1])
        intDay = int(objDate.strftime(\"%j\"))
        intInterval = 0
        for i in range(1, 366, DatesInterval):
            if intDay >= i and intDay < i+DatesInterval:
                intInterval = i
                break
        objFeature.SetValue(FieldName1, intInterval)

        # Calculate Raster Path
        objImage = \"00\" + strImageDate
        strTif = RasterFolder + RasterPrefix + objDate.strftime(\"%Y\") + DatePrefix + objImage[-3:] + \".tif\"
        objFeature.SetValue(FieldName3, strTif)  

        objFeatures.UpdateRow(objFeature)
        objFeature = objFeatures.Next()
    del objFeature
    del objFeatures

    print "Calculated ImgDate"
    print "Calculated NDVI Raster Path"
    gp.addmessage("Calculated Raster Path in " + FieldName3)

    # Process: Sample Rasters Listed in Fields...
    gp.ArcGISRasterSamplerSampleRastersInFields_GeoEco(InputFC, FieldName3, FieldName2, "", "NEAREST", "", "", "")
    ...etc....

3rdOrderSampleRastersbyDate_Notworking.py.zip

Hi Brad,

Thanks for the explanation. That helps a lot.

I got both field calculations to work perfectly using the following in the code block:

import datetime
def Calc(strDate):
       lstDate = map(int, strDate.split("/")) # create list of date integers  D(D), M(M), YYYY
       objDate = datetime.date(lstDate[2], lstDate[0], lstDate[1]) # create date object
       intDay = int(objDate.strftime("%j")) # integer day of the year
       for i in range(1, 366, 16):
   if intDay >= i and intDay < i+16:
               return  i
    return 0

import datetime
def Calc(strDate, strImageDate):
      lstDate = map(int, strDate.split("/")) # create list of date integers  D(D), M(M), YYYY
      objDate = datetime.date(lstDate[2], lstDate[0], lstDate[1]) # create date object
  objImage = "00" + strImageDate
      strTif = r"J:\GEOG683\HEB_NDVI_GEO" + r"\Montana_Canada_NDVI_A" + objDate.strftime("%Y") + "D" +          objImage[-3:] + ".tif"
      return strTif

Just was hoping you could clarify a couple more things. First in the Expression I put either Calc(!Date_Time!) or Calc(!Date_Time!,!ImgDate!) ....do I put this expression because it means the code block is calculating using values from the fields Date_Time and ImgDate?

Unfortunately, I am still having another issue that I can't resolve. I tried all weekend to resolve it, but couldn't figure it out. My issue is when I export the above codeblocks to a python script outside of model builder that allows the user to input the name of the field (i.e. a field name other than ImgDate) and dates interval (i.e value other then 16) using sys.argv it doesn't work. It seems the code within the code block string doesn't recognize these variables from outside the code block expression.

Specifically its not recognizing the variable assigned to DatesInterval inside the code block.

Here is the orignial python code exported from Modelbuilder that works great as long as the field is ImgDate and Date range is 16.

gp.CalculateField_management(InputFC, "ImgDate", "Calc(!Date_Time!)", "PYTHON", "import datetime\\ndef Calc(strDate):\\n    lstDate = map(int, strDate.split(\"/\")) # create list of date integers  D(D), M(M), YYYY\\n    objDate = datetime.date(lstDate[2], lstDate[0], lstDate[1]) # create date object\\n    intDay = int(objDate.strftime(\"%j\")) # integer day of the year\\n    for i in range(1, 366, 16):\\n        if intDay >= i and intDay < i+16:\\n            return  i\\n    return 0")
##print "Calculated ImgDate"

However, when I attmpet to alter this code with the variables for the field name (FieldName1) and variable for the image dates (DatesInterval) the code doesn't seem to pass the DatesInterval assignment within the codeblock string. I tried to assign it within the code block but it still says ExecuteError: ERROR 000539: Error running expression: Calc("5/29/2006") <type 'exceptions.UnboundLocalError'>: local variable 'DatesInterval' referenced before assignment

gp.CalculateField_management(InputFC, FieldName1, "Calc(!Date_Time!)", "PYTHON", "import datetime\\ndef Calc(strDate):\\n    DatesInterval = +DatesInterval\\n    lstDate = map(int, strDate.split(\"/\")) # create list of date integers  D(D), M(M), YYYY\\n    objDate = datetime.date(lstDate[2], lstDate[0], lstDate[1]) # create date object\\n    intDay = int(objDate.strftime(\"%j\")) # integer day of the year\\n    for i in range(1, 366, DatesInterval):\\n        if intDay >= i and intDay < i+DatesInterval:\\n            return  i\\n    return 0")
print "Calculated ImgDate"

Do you mind showing me how to pass a python variable/argument from outside the codeblock. I've attached the entire code of python if that helps.

Thank you so much for your detailed input. Your effort and help is greatly appreciated.

Hi Brad,

Thank you so much for your patience and assistance. However, I am still getting an error when I run the Calculate Field. However, now my error is:

ERROR 000539: Error running expression: Calc("6/16/2006") <type 'exceptions.ValueError'>: month must be in 1..12
Failed to execute (Calculate Field (3)).

I think this must mean my Date_Time field isn't in the correct format. Reading the ArcGIS help online it mentions that shapefiles and coverages store Dates differently as it only stores dates and not time. In anycase my dataset is a shapefile and I'm working in 9.3.1 if that makes a difference.

I apologize for not figuring this out myself, but I've having some trouble understanding the details of the code as I'm new to Python.

Thanks again for you help!

Let's start with this line:

lstDate = map(int, strDate.split("/")) # create list of date integers  D(D), M(M), YYYY

(note that comments are preceded by #, so anything following # is ignored)

This is actually two commands joined as one: the "map" function and the "split" string method.

Say you have a date of "6/16/2006". The string method

strDate.split("/")

creates a Python list by splitting the string at the forward slash, with a result of ["6", "16", "2006"]. So now Python interprets the line as:

lstDate = map(int, ["6", "16", "2006"])

The map function simply says "take each element in the list (second parameter) and pass it into the function defined in the first parameter". In this case, each element is passed into the int() function, converting the strings in the list to integers. So now Python interprets the line as:

lstDate = [6, 16, 2006]

To access each element in the list you append an index number in square brackets to the list variable name. The index numbering starts with 0, so you can extract each value like this:

lstDate[0] = 6        # month
lstDate[1] = 16      # date
lstDate[2] = 2006   # year

Now jump into this line:

objDate = datetime.date(lstDate[2], lstDate[1], lstDate[0]) # create date object

The date object is created by passing three parameters, as integers, to the datetime.date method in the following order:

datetime.date(<year>, <month>, <date>)

The date format in my data was DD/MM/YYYY, so lstDate[0] was day, lstDate[1], was month, and lstDate[2] was year. Therefore, the parameters are:

datetime.date(lstDate[2], lstDate[1], lstDate[0])

Your data (and I didn't notice before my last post) is MM/DD/YYYY. Therefore, you simply need to change the order of the parameters to fix the error.

objDate = datetime.date(lstDate[2], lstDate[0], lstDate[1]) # create date object

Hi Brad,

Thank you so much for your patience and assistance. However, I am still getting an error when I run the Calculate Field. However, now my error is:

ERROR 000539: Error running expression: Calc("6/16/2006") <type 'exceptions.ValueError'>: month must be in 1..12
Failed to execute (Calculate Field (3)).

I think this must mean my Date_Time field isn't in the correct format. Reading the ArcGIS help online it mentions that shapefiles and coverages store Dates differently as it only stores dates and not time. In anycase my dataset is a shapefile and I'm working in 9.3.1 if that makes a difference.

I apologize for not figuring this out myself, but I've having some trouble understanding the details of the code as I'm new to Python.

Thanks again for you help!

For the second script, you need to (1) create the date object, (2) pass the ImgDate attribute as a parameter to the Calc function, and (3) return the result of the function.

See if this works, using Calc(!Date_Time!, !ImgDate!) as the expression:

import datetime
def Calc(strDate, strImageDate):
    lstDate = map(int, strDate.split("/")) # create list of date integers  D(D), M(M), YYYY
    objDate = datetime.date(lstDate[2], lstDate[1], lstDate[0]) # create date object
    strTif = r"J:\GEOG683\HED_NDVI_GEO" + r"\Montana_Canada_NDVI_A" + objDate.strftime("%Y") + "D" + strImageDate + ".tif"
    return strTif

Alternatively, you can shorten this quite a bit. Since you just need the year in this script you could directly split it out from Date_Time attribute:

import datetime
def Calc(strDate, strImageDate):
    return r"J:\GEOG683\HED_NDVI_GEO" + r"\Montana_Canada_NDVI_A" + strDate.split("/")[2] + "D" + strImageDate + ".tif"

Hi Brad,

Thanks for the reply. I believe what you have suggested is exactly what I need and is much more efficient then my current vb code! However, I am still struggling with the syntax and getting the Calculate Field tool to work properly. I keep getting the following error.

ERROR 000539: Error running expression: Calc("1/29/2007") <type 'exceptions.NameError'>: global name 'objDate' is not defined
Failed to execute (Calculate Field (3))

I've attached screen shots of the parameters I entered in the Calculate Field tool. I looked through the link you sent, but still can't seem to figure out the error. My field in the attribute table is Named Date_Time and is Type Date. The date is formated M/DD/YYYY (1/29/2007).

Any futher help would be greatly appreciated!

Cheers,
Karl

CalculateField2.jpg

CalculateField.jpg

As mentioned above you can use the datetime module to convert your dates to the day of the year.

The codeblock below demonstrates how to do it.

The first line splits the date into a Python list containing the day, month, and year. Note the map function runs the int function on each part to convert them from strings to integers.

The second line creates a date object using the Python list.

The third line converts the date to the day of the year.

import datetime
def Calc(strDate):
    lstDate = map(int, strDate.split("/")) # create list of date integers  D(D), M(M), YYYY
    objDate = datetime.date(lstDate[2], lstDate[1], lstDate[0]) # create date object
    intDay = int(objDate.strftime("%j")) # integer day of the year
    for i in range(1, 366, 16):
        if intDay >= i and intDay < i+16:
            return i
    return 0

(Use Calc(!Date_Time!) as the EXPRESSION.)

Creating a string such as "2006D032.tif" is simply a matter of concatenating the parts of the date object using stftime formatting (dig around here http://docs.python.org/library/datetime.html for more info regarding format codes).


strTif = objDate.strftime("%Y") + "D" + objDate.strftime("%j") + ".tif"

Hello all,

I am having a similar issue of converting a VB code block to a equivalent python code block for use in the Calculate Field tool. I used the following VB code with NewString as the expression in Modelbuilder and it works fine; however, I want to run the Calculate Field as a Python Script so seems like I need to convert it. The objective is to get the three digit date from the time field (i.e 000 to 366) and then assign it the appropriate image date based on where it fits in the select case. So in this case the field calculated is ImgDate and ImgDate = NewString from expression below

dim NewString as string
Select case (Right("00" + CStr(DatePart("y", [Date_Time])), 3))
case 1 to 16
     NewString = "1"
case 17 to  32
     NewString = "17"
case 33 to 48
     NewString = "33"
case 49 to  64
     NewString = "49"
case 65 to 80
     NewString = "65"
case 81 to  96
     NewString = "81"
case 97 to 112
     NewString = "97"
case 113 to  128
     NewString = "113"
case 129 to 144
     NewString = "129"
case 145 to  160
     NewString = "145"
case 161 to 176
     NewString = "161"
case 177 to  192
     NewString = "177"
case 193 to 208
     NewString = "193"
case 209 to  224
     NewString = "209"
case 225 to 240
     NewString = "225"
case 241 to  256
     NewString = "241"
case 257 to  272
     NewString = "257"
case 273 to 288
     NewString = "273"
case 289 to  304
     NewString = "289"
case 305 to 320
     NewString = "305"
case 321 to  336
     NewString = "321"
case 337 to 352
     NewString = "337"
case 353 to  367
     NewString = "353"
case else
     NewString = "Error"
end select

I think I've got the select case statements figured out, but can't seem to figure out how to get the appropriate three digit date value as a string from a DateTime Field

I tried this in the code block of Modelbuilder but it doesn't work:

NewString =  (rstrip("00" + Str(DatePart("y", !Date_Time!)), 3))

def Calc(NewString):
    if NewString >= 1 or NewString <= 16:
        return 1
    elif NewString >= 17 or NewString <=32:
        return 17
    elif NewString >= 33 or NewString <=48:
        return 33
    else:
       return 0

I"m also having trouble converting this VB line that takes the image date determined in the code above and adds the year to it and .tif extension to the end (e.g 2006D032.tif) as well.

CStr(DatePart("yyyy", [Date_Time])) + "D" +  Right("00" + CStr([ImgDate]), 3) + ".tif"

Any help would be greatly appreciated. Thanks in advance.

Cheers!

Thank you very much

ChrisSnyder

Mustafa needs help with the new map algebra syntax (v10 syntax). I haven't gotten there yet, but... Here's the intro to the help topic though: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/What_is_Map_Algebra/00p600000002000000/

vb function is: EXPAND ([Streams_rr2m],10,LIST,1.2 )

OK, i will say you the story from the start, i want to make a (tip) to make a buffering raster by spatial analyst tool, so to make this, we must be open (Raster Calc) and then type this syntax in the field raster calc: EXPAND ([Streams_rr2m],10,LIST,1.2 ) it was made by vb, so tha spatial analyst command, EXPAND: it mean that fatten up the zones, which is reputed to be the raster equivalent of the vector produce BUFFER. so i just need only, if this proper syntax in Python field, i do not know this exactly.
thank you

NiklasNorrthon

I don't know what your VB function is supposed to do. If you can give an example of unformatted data, and how you want it formatted I might be able to help you.

Here is a python crash course for the field calculator (assuming ArcGIS 10):

First of all python is just as easy as VB (if not easier). It's just a different language, so the syntax is not identical to VB. That means that you can't write VB in python, just as you can't write C++, Perl or C# in python, so yes you need to learn a little python to write python.

Second: The field calculator is actually extending the python language with the notation of "fields names" just as it did with VB. In VB field calculator you quote field names with sqaure brackets: [field_name]. In python you do the same, but with exclamation marks instead: !field_name!. That is because square brackets already have a different meaning in python.

Third: String formatting in python is much more powerful than i VB, and also very different from VB. To format a string in python one creates a "format string" and then use the format operator:
"This is a %s with the integer %d and the float %.4f" % ('format string', 42, 3.14159265)
Fourth: To pick substring from a string, one use index and slicing:
"mississippi"[0] # -> "m"
"mississippi"[:4] # -> "miss" # End at the 4th character
"mississippi"[-4:] # ->"ippi" # Start is 4th from the right
"mississippi"[::-1] # -> "ippississim" # Stepping backwards
"mississippi"[1::3] # -> "iiii" # Start at 1, and step 3
So for some field calculator examples:
To copy the contents from one field to another, just quote the source field name in exclamation marks:
!source_field!
To copy and format floating point numbers to a text field, use a format string:
"%.3f" % !source_float_field!
To fill a column with the time of day, formatted in 12 hour format:
First check the "Show codeblock" checkbox, then in the Pre-Logic Script Code box enter the following:
import datetime
t = datetime.datetime.now()
Then in the calc field code box below enter the following:
t.strftime('%I:%M:%S %p) # See python help for strftime for details
Given a float field with POSIX timestamps (seconds since epoch). To convert that to a date and time string in ISO format (2010-01-15 06:43:12):
in the pre-logic box enter:
import datetime
and in the calc window enter:
datetime.datetime.fromtimestamp(!time_stamp_field!).strftime('%Y-%m-%d %H:%M:%S')
Try these examples out and then come back with more specific questions about the Calculate Field functionallity. Also keep in mind that some people here (me included), might not be fluent in VB, so examples of what you expect specific VB code snippets to do is helpful.

Thank u very much niklas.norrthon, i had tried to write the syntax again by following ur post,put the same problem had appeared again, so if you want to try this by urself, and what can i do with this expression
for example
Streams_rr2m],10,LIST,1.2)(vb)
thank you very much again

NiklasNorrthon

Here is a python crash course for the field calculator (assuming ArcGIS 10):

First of all python is just as easy as VB (if not easier). It's just a different language, so the syntax is not identical to VB. That means that you can't write VB in python, just as you can't write C++, Perl or C# in python, so yes you need to learn a little python to write python.

Second: The field calculator is actually extending the python language with the notation of "fields names" just as it did with VB. In VB field calculator you quote field names with sqaure brackets: [field_name]. In python you do the same, but with exclamation marks instead: !field_name!. That is because square brackets already have a different meaning in python.

Third: String formatting in python is much more powerful than i VB, and also very different from VB. To format a string in python one creates a "format string" and then use the format operator:

"This is a %s with the integer %d and the float %.4f" % ('format string', 42, 3.14159265)

Fourth: To pick substring from a string, one use index and slicing:

"mississippi"[0] # -> "m"
"mississippi"[:4] # -> "miss" # End at the 4th character
"mississippi"[-4:] # ->"ippi" # Start is 4th from the right
"mississippi"[::-1] # -> "ippississim" # Stepping backwards
"mississippi"[1::3] # -> "iiii" # Start at 1, and step 3

So for some field calculator examples:
To copy the contents from one field to another, just quote the source field name in exclamation marks:

!source_field!

To copy and format floating point numbers to a text field, use a format string:

"%.3f" % !source_float_field!

To fill a column with the time of day, formatted in 12 hour format:
First check the "Show codeblock" checkbox, then in the Pre-Logic Script Code box enter the following:

import datetime
t = datetime.datetime.now()

Then in the calc field code box below enter the following:

t.strftime('%I:%M:%S %p) # See python help for strftime for details

Given a float field with POSIX timestamps (seconds since epoch). To convert that to a date and time string in ISO format (2010-01-15 06:43:12):
in the pre-logic box enter:

import datetime

and in the calc window enter:

datetime.datetime.fromtimestamp(!time_stamp_field!).strftime('%Y-%m-%d %H:%M:%S')

Try these examples out and then come back with more specific questions about the Calculate Field functionallity. Also keep in mind that some people here (me included), might not be fluent in VB, so examples of what you expect specific VB code snippets to do is helpful.

I have ArcGis 10,
i have tried to apply this syntax ("expand(" + inputGrd + ", 10, 'LIST', 1.2)"), but i have the same error.

thank you

ChrisSnyder

Are you using ArcGIS v10 or v9.3? In v10 there is a new raster calculator syntax that I am not up and running with yet. However, even in v10 you can still use the good old MapAlgebra syntax via Python. For example:

#EXPAND([Streams_rr2m],10,LIST,1.2)
import arcgisscripting
gp = arcgisscripting.create(9.3)
gp.CheckOutExtension("Spatial")
inputGrd = r"C:\temp\input"
somaExp = "expand(" + inputGrd + ", 10, 'LIST', 1.2)"
outputGrd = r"C:\temp\output"
gp.SingleOutputMapAlgebra_sa(somaExp, outputGrd, "")

#INT([Ran_Ras] * 10) + 1
import arcgisscripting
gp = arcgisscripting.create(9.3)
gp.CheckOutExtension("Spatial")
inputGrd = r"C:\temp\input"
somaExp = "int(" + inputGrd + " * 10 + 1)"
outputGrd = r"C:\temp\output"
gp.SingleOutputMapAlgebra_sa(somaExp, outputGrd, "")

#[Angles] * 57.296
import arcgisscripting
gp = arcgisscripting.create(9.3)
gp.CheckOutExtension("Spatial")
inputGrd = r"C:\temp\input"
somaExp = inputGrd + " * 57.296"
outputGrd = r"C:\temp\output"
gp.SingleOutputMapAlgebra_sa(somaExp, outputGrd, "")

OK, thank you very much, for example,

EXPAND([Streams_rr2m],10,LIST,1.2)

INT([Ran_Ras] * 10) + 1

[Angles] * 57.296

so if you have any information about typing expressions by python plz help me, precisely (Raster Calculator operators and functions)
thank you very much again for interesting and following my post

ChrisSnyder

Sounds like you need to learn Python...

Do you have any specific examples of VBA code you need to convert to Python?