data has been uploaded into DOMO.
the first column is in integer type like '45319' but actually it is DATE(Jan-28-2024),
how can i change it to DATE in DOMO without changing the original spreadsheet data type?
thanks
Admin » Governance » Toolkit » Schema Management Schema Management lets you change the column type (data structure) of a dataset. If your dataset has an integer as the data type for a field, you can change it to a date.
You can use the following beastmode to correct the date:
date_add(date('1899-12-31'), interval floor(あなたの日付フィールド) day)
Colemen's answer converts the information to date. There is a toolkit function for Schema Management to modify structure for that date. Please mark Colemen's answer as yes if it solves your issue.
@ArborRose where is the toolkit function for Schema Management? thanks,
thank you. I am asking my DOMO administrator to update my user.
@ArborRose
3PL send me daily storage data, in the file, each sheet reflects that day's data, for example, sheet '4.26' reflect 26th April data, sheet '4.25' reflects 25th April data. those sheets are accumulated in one file called 'month to date' storage report with each day's data in different sheet.
I'd like to connect this daily data file with a DOMO designed card to automatically append data to the card.
I have two difficulties:
What is your opinion on above?
Thank you.