Taking previous month output as a input dynamically

Question

Hi All,

I'm new to app creation and creating one app where user first select Year and Month of which data needs to process further. Later based on the user selection (Based on the Year Month which user selected) we needs to pick previous month output as a input so how I'll achieve this every time.

So, I have implemented list box through which user select Year and Month. The workflow generate .pdf file as a output which contains the date of which it's generating result. In that workflow there is one input which contain the previous month output e.g. if user selecting Aug'2021 then it will take output of Jul'21 as a input. So the input should be selected Month-1 based on the user selection of Year Month.

Please help me to implement this logic.

poojamate92 · Answer

Hi @RolandSchubert ,

Appreciate your quick response !!

However, please tell me how to pass current month selection in date function. The attached screenshot showing the workflow where in green box user make Year Month selection later in Red box based on the user selection I have to input previous output as input.

Kindly check the screenshot and let me know the solution.

RolandSchubert · Answer

Hi @poojamate92 ,

if I got you right, the DateTime functions can do the job:

DateTimeFormat(DateTimeAdd(DateTimeParse([Selection], '%b %Y'), -1, 'month'), '%b %Y')

DateTimeParse([Selection], '%b %Y') converts the selection (e.g. Aug 2021) to a date data type. DateTimeAdd( ..., -1, 'month') finds the previous month and DateTimeFormat creates the required output format.

Hope this is helpful, let me know if it works for you.

Best,

Roland