Hi all -
I have a use case where I need to pass a string into a database connector as a parameter for a stored procedure. Specifically I need to pass a string formatted date value like this - '2018-05-01' where this would be the first of the month. From a requirements standpoint:
- Need the first day of the current month. If I ran the process on May 15th, I'd need the value to return as '2018-05-01'.
- Need to have the date formatted as a string in the above syntax
I'm trying to figure out the best way to go about this - seems like it should be a straight forward thing to do but I'm unsure of how to resolve.