I am using pydomo in a jupyter notebook to write a dataframe to a domo instance using the ds_create or ds_update method. The date value stored in my dataframe is formatted as '%m-%d-%Y' and gets converted to a date timestamp during the execution. The issue I'm having is the date is also converted to UTC. I attempted to identify the date values as UTC in the dataframe object, giving it a type datetime64[ns, 'UTC'], but that gets converted to a string value.
I working on a work around to since this throws off all the date values I'm currently using by 1 day, setting January 4th as January 3rd. However a streamlined approach that allowed a time zone identification would be very helpful.
Thank you
I am using pydomo in a jupyter notebook to write a dataframe to a domo instance using the ds_create or ds_update method. The date value stored in my dataframe is formatted as '%m-%d-%Y' and gets converted to a date timestamp during the execution. The issue I'm having is the date is also converted to UTC. I attempted to identify the date values as UTC in the dataframe object, giving it a type datetime64[ns, 'UTC'], but that gets converted to a string value.
I working on a work around to since this throws off all the date values I'm currently using by 1 day, setting January 4th as January 3rd. However a streamlined approach that allowed a time zone identification would be very helpful.
Thank you