How to cast as datetime in Domo workbench?
I need to add a date field to a job in workbench where the date is static, but not the current date.
I have been attempting to create a calculated transform and expected to do something similar to:
to_date('05/23/2018') or cast('2018-05-23' as datetime)
Neither of those are available functions, however, and I don't see anything like them in the list of available date/time functions.
Incidentally, I have played with changing quotes, etc, but I cannot get a calculation to validate.
There was a similar question asked and resolved by using the today() function, but I need to set to a previous date.
I can set the calculation to a simple sting (05/23/2018) easily enough, but then the schema either converts the field to a string, or nulls the cells as invalid (because that is the default setting) if I lock the data type.
Not sure what I am missing. Please help me create a date field set to static previous date. Thanks in advance
- 10.7K All Categories
- 13 Getting Started in the Community
- 35 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 500 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- Private Company Board