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