Add date/time field witn API_AddField

Question

I'm tying to figure out how to add a date/time field in the table using api call API_AddField.
There's no such type mentioned in the official API reference.

------------------------------
Stepan Gurov
------------------------------

austink · Answer

Add that field as a date field and then use API_SetFieldProperties with the&nbsp;display_time tag in there. I'm sure you will need more than just that but I will link you to the help documentation."display_time:&nbsp;Specifies whether the field shows date only in Quick Base UI or both date and time. This option turns a date field into a date-time field."https://help.quickbase.com/api-guide/setfieldproperties.html

stepangurov · Answer

Well, since for date/time fields display_time&nbsp;tag works properly,&nbsp;for date type fields it doesn't automatically switch type to date/time when applying the tag via api.Any api calls that can explicitly switch field type to date/time?------------------------------Stepan Gurov------------------------------

stepangurov · Answer

In the meantime I've figured out that setting a field type to 'timestamp' at creation is also possible (though it's not mentioned in the API reference), so it basically solves my problem :)------------------------------Stepan Gurov------------------------------

Forum Discussion

Add date/time field witn API_AddField

Related Content

Formula Date Time Will not Accept Null Condition

Convert timestamp to Date/Time

Looking for Date/Time Field 1 = Date/Time Field 2 pipeline jinja

Date/Time format

Using pipelines to log the date/time including the seconds of a record change