Date format issue

Harsh

Harsh ✭✭

03/30/22 in API & Developers

Hello,

Currently we get format like ",,,,,,,,,,,,,,,,1" for date column type. How can we get actual date format like "yyyy-mm-dd"?

Or if there is any way to convert format string ",,,,,,,,,,,,,,,,1" to datetime format?

0 ·

Answers

Paul Newcome Community Champion

03/30/22

Are you able to provide some screenshots for reference?

CERTIFIED SMARTSHEET PLATINUM PARTNER
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Training opportunities with my team and I
0 · Share on Facebook Share on Twitter

Categories

NEW Smartsheet API Documentation - bookmark the updated link! https://developers.smartsheet.com

Trending in API & Developers

How do I integrate AMEX charges into Smartsheet
We are trying to automate our expenses. Daily we'll copy and paste transactions for our staff to identify, and attach receipts. We'd like to automate the copy and paste sequence and have transactions automatically be pulled from AMEX daily. Ideas?
unable to move a row in Python
I use Smartsheet to govern a project that does ~10k tasks per year so automating as much of the project is extremely helpful. I have multiple python scripts that are updating sheets and grabbing data form sheets but this is the first time i have tried to move data in a sheet. I am trying to move a row below another row…
Snowflake Data into Smartsheet?
Hey everyone, Do you know if there is a way to connect Snowflake data into Smartsheet using the API? I have found many resources on getting Smartsheet data into Snowflake but nothing on the other way around. We are trying to either do something native within Smartsheet or use an open-source software such as Airbyte.