AnsweredAssumed Answered

Generate Parameter Value - Dynamically

Question asked by tom.kline365190 on May 29, 2018
Latest reply on May 29, 2018 by tom.kline365190

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.

Outcomes