topic Date field attribute not displaying correctly in Python Questions

Date field attribute not displaying correctly

H_A_D_Padmasiri — Fri, 25 Apr 2014 10:01:16 GMT

Dear Sir
I entered date field as variable like VDate = Sys.argv[4] using arcpy.CalculateField_management("BLD_PG", "BLD_PG_DT", VDate, "PYTHON_9.3", "")
But in attribute table attribute of the Date field look like 12:01:00 AM. How to correct it?

Thanks

Padmasiri

Re: Date field attribute not displaying correctly

JakeSkinner — Fri, 25 Apr 2014 11:15:53 GMT

Hi Padmisiri,

You will want to format the date like the following:

time.strftime('05/02/2014')

Ex:

arcpy.CalculateField_management("BLD_PG", "BLD_PG_DT", "time.strftime('05/02/2014')", "PYTHON")

Re: Date field attribute not displaying correctly

H_A_D_Padmasiri — Mon, 28 Apr 2014 10:11:58 GMT

Hi Padmisiri,

You will want to format the date like the following:

time.strftime('05/02/2014')

Ex:
arcpy.CalculateField_management("BLD_PG", "BLD_PG_DT", "time.strftime('05/02/2014')", "PYTHON")

Can you please explain How to enter '05/02/2014' as a variable. (VDate)

Thanks

Re: Date field attribute not displaying correctly

JakeSkinner — Mon, 28 Apr 2014 11:30:47 GMT

Here is an example:

VDate = "time.strftime('05/02/2014')"

Re: Date field attribute not displaying correctly

H_A_D_Padmasiri — Wed, 30 Apr 2014 07:20:04 GMT

Here is an example:
VDate = "time.strftime('05/02/2014')"

Thank you for your answer.it runs correctly, But I add a field called "BLD_PG_DT"(Date Type) it gives me following error.
I cant understand the error. can you correct it.

Thanks

Padmasiri

VDate = sys.argv[4] # This date value from the calender
arcpy.AddField_management("BLD_PG", "BLD_PG_DT", "DATE", "", "", "", "Validity Date", "NULLABLE", "NON_REQUIRED", "")
arcpy.CalculateField_management("BLD_PG", "BLD_PG_DT", "time.strftime('VDate')", "PYTHON_9.3", "")

Traceback (most recent call last):
File "J:\Gampaha\Scripts\Creating_Building.py", line 57, in <module>
arcpy.CalculateField_management("BLD_PG", "BLD_PG_DT", "time.strftime('VDate')", "PYTHON_9.3", "")
File "c:\program files\arcgis\desktop10.1\arcpy\arcpy\management.py", line 3128, in CalculateField
raise e
ExecuteError: ERROR 999999: Error executing function.
The value type is incompatible with the field type. [BLD_PG_DT]
Failed to execute (CalculateField).

Failed to execute (LISTool1.02).

Re: Date field attribute not displaying correctly

JakeSkinner — Wed, 30 Apr 2014 09:15:02 GMT

Can you post your entire code? Be sure to wrap it in the appropriate

 tags.

Re: Date field attribute not displaying correctly

H_A_D_Padmasiri — Fri, 02 May 2014 02:36:18 GMT

Can you post your entire code? Be sure to wrap it in the appropriate
 tags.

Dear sir

My entire code is send here with. Pl see attachment.

Thanks

Padmasiri

Re: Date field attribute not displaying correctly

JakeSkinner — Fri, 02 May 2014 10:28:57 GMT

For some reason, I could not get this to work with 'sys.argv' but I was able to with arcpy.GetParameterAsText. Are you able to use the GetParameterAsText rather than sys.argv?

Re: Date field attribute not displaying correctly

H_A_D_Padmasiri — Mon, 05 May 2014 09:44:30 GMT

For some reason, I could not get this to work with 'sys.argv' but I was able to with arcpy.GetParameterAsText. Are you able to use the GetParameterAsText rather than sys.argv?

Dear sir

When I save a date as a variyable, which I take from the calender like (mm/dd/yyyy).
My question is why that variyable directly enter to date field without formatting ?
What is the correct method to enter in to the date field which I take from the calender?
I cant understand what is the purpose of using calender.

Kindly explain me.

Thanks

Padmasiri

Re: Date field attribute not displaying correctly

JakeSkinner — Sat, 11 Dec 2021 18:12:50 GMT

Hi Padmasiri,

Try replacing your sys.argv arguments with arcpy.GetParameterAsText. Here is an example:

# Import arcpy module
import arcpy
import os
from arcpy import env
import shutil
import sys
import time

# Local variables:
Cad_File = arcpy.GetParameterAsText(1)#J:\Gampaha\510272\51027202.dwg
Pro_File = arcpy.GetParameterAsText(2)#I:\Projections\ProSriLanka99_5
Folder_Loca = arcpy.GetParameterAsText(3)#J:\Gampaha
VDate = "time.strftime('" + arcpy.GetParameterAsText(4) + "')"
Folder_Name = os.path.splitext(os.path.basename(Cad_File))[0]#51027202
Out_folder = os.path.join(Folder_Loca, Folder_Name)#J:\Gampaha\51027202
Gdb_Name = "CAD" + Folder_Name#CAD51027202
Gdb_Name1 = "CM" + Folder_Name#CM51027202
Gdb_Path = os.path.join(Out_folder, Gdb_Name)#J:\Gampaha\51027202\CAD51027202
Gdb_Path1 = os.path.join(Out_folder, Gdb_Name1)#J:\Gampaha\51027202\CM51027202
Fea_Dset_Name = "CAD" + Folder_Name#CAD51027202
Fea_Dset_Name1 = "CM" + Folder_Name#CAD51027202
Fea_Class_Path = os.path.join(Gdb_Path1 + ".gdb", Fea_Dset_Name1)#J:\Gampaha\51027202\CM51027202.gdb\CM51027202
if os.path.isdir(Out_folder):
    arcpy.env.workspace = Out_folder
    Gdb_List = arcpy.ListWorkspaces("", "FileGDB")
    for GDB in Gdb_List:
        arcpy.Delete_management(GDB)
    shutil.rmtree(Out_folder)
Ws_Path = Gdb_Path + ".gdb" + os.sep + Gdb_Name
arcpy.DefineProjection_management(Cad_File, Pro_File)
arcpy.CreateFolder_management(Folder_Loca, Folder_Name)#J:\Gampaha\510272\51027202
arcpy.env.workspace = Out_folder
arcpy.CreateFileGDB_management(Out_folder, Gdb_Name, "CURRENT")#J:\Gampaha\51027202\CAD51027202.gdb
arcpy.CreateFileGDB_management(Out_folder, Gdb_Name1, "CURRENT")#J:\Gampaha\51027202\CM51027202.gdb
arcpy.CreateFeatureDataset_management(Gdb_Path1 + ".gdb", Fea_Dset_Name1, Pro_File)#J:\Gampaha\51027202\CM51027202.gdb\CAD51027202
env.workspace = Gdb_Path + os.sep + Fea_Dset_Name
#arcpy.env.Scratchworkspace = Gdb_Path
arcpy.CADToGeodatabase_conversion(Cad_File, Gdb_Path + ".gdb", Fea_Dset_Name, "2000")
arcpy.CreateTopology_management(Fea_Class_Path, "PCL_LN_Topology", 0.01)
Polyline = Ws_Path + os.sep + "Polyline"
Pnt = Ws_Path + os.sep + "Point"
PLN_Topology = Fea_Class_Path + os.sep + "PCL_LN_Topology"
Fea_Class = Fea_Class_Path + os.sep + "BLD_LN" #NL
#Creating Structure Feature Class
env.workspace = Fea_Class_Path #NL
arcpy.FeatureClassToFeatureClass_conversion(Polyline, Fea_Class_Path, "BLD_LN", " \"Layer\" = 'OBJ-MAN-MADE' ")
arcpy.FeatureToPolygon_management(Fea_Class, Fea_Class_Path + os.sep + "BLD_PG", 0.01, "ATTRIBUTES", "")
arcpy.AddField_management("BLD_PG", "BLD_PG_NM", "TEXT", "", "", "50", "Building Name", "NULLABLE", "NON_REQUIRED", "")
arcpy.AddField_management("BLD_PG", "BLD_PG_CD", "SHORT", "", "", "", "BLD SD Code", "NULLABLE", "NON_REQUIRED", "")
SubType_Dict = {"0": "Permanent Building", "1": "Temporary Building", "2": "Building Underconstruction"}
arcpy.SetSubtypeField_management("BLD_PG", "BLD_PG_CD")
for code in SubType_Dict:
        arcpy.AddSubtype_management("BLD_PG", code, SubType_Dict)
arcpy.SetDefaultSubtype_management("BLD_PG", "0")
arcpy.AddField_management("BLD_PG", "BLD_PG_DT", "DATE", "", "", "", "Validity Date", "NULLABLE", "NON_REQUIRED", "")
arcpy.CalculateField_management("BLD_PG", "BLD_PG_DT", VDate, "PYTHON_9.3", "")

Re: Date field attribute not displaying correctly

JakeSkinner — Mon, 05 May 2014 10:05:04 GMT

Hi Padmasiri,

Try replacing your sys.argv arguments with arcpy.GetParameterAsText. Attached is an example.

Re: Date field attribute not displaying correctly

H_A_D_Padmasiri — Tue, 06 May 2014 06:28:16 GMT

Hi Padmasiri,

Try replacing your sys.argv arguments with arcpy.GetParameterAsText. Attached is an example.

Dear sir

I replacing my sys.argv arguments with arcpy.GetParameterAsText and try. But it gives me following error.

Executing: LISTool1.02 J:\Gampaha\270054\27005402.dxf I:\Projections\ProSriLanka99_5.prj J:\Gampaha 06/19/2013
Start Time: Tue May 06 12:50:08 2014
Running script LISTool1.02...

Traceback (most recent call last):
File "J:\Gampaha\Scripts\Creating_Building.py", line 13, in <module>
    VDate = "time.strftime('" + arcpy.GetParameterAsText(4) + "')"
File "c:\program files\arcgis\desktop10.1\arcpy\arcpy\__init__.py", line 592, in GetParameterAsText
    return gp.getParameterAsText(index)
File "c:\program files\arcgis\desktop10.1\arcpy\arcpy\geoprocessing\_base.py", line 224, in getParameterAsText
    self._gp.GetParameterAsText(*gp_fixargs(args, True)))
RuntimeError: Object: Error in getting parameter as text

Failed to execute (LISTool1.02).
Failed at Tue May 06 12:50:08 2014 (Elapsed Time: 0.00 seconds)

Thanks

Padmasiri