Issue
When using the DATE() function in a calculated field with an Oracle data source, the following error might occur:ORA-01861: literal does not match format string
DATE( STR ([Year]) + "-" + STR([Month]) + "-1" )
The matching DATEPARSE() calculation would be
DATEPARSE("yyyy-MM-dd", (STR ([Year]) + "-" + STR([Month]) + "-1" ))