updating text field with date

[shakir]

HI Folks,

I am trying to update a text field coulmn in a table with date data. The script is as follows:

gp.calculatefield_management("ch_er_primary.shp", "FINAL_CDT", "FORMAT([FINAL_ACTI],""mm/dd/yyyy"")")

here the final_cdt : is string field and final_acti is date field.



The error I am getting:
Traceback (most recent call last):
File "V:\data\tst\add_field.py", line 35, in ?
gp.calculatefield_management("ch_er_primary.shp", "FINAL_CDT", "FORMAT([FINAL_ACTI],""mm/dd/yyyy"")")
File "<COMObject esriGeoprocessing.GpDispatch.1>", line 2, in calculatefield_management
com_error: (-2147467259, 'Unspecified error', None, None)


I really appreciate any help I could get on this problem.


Thanks in advance.

shakir