String Word Month date to the End of the month format

[arjundelara]

Hi All,

Working on a output that result on the end of the month result.

if the value is March the result is March = 31/3/2020

Regards,

[atcodedog05 · Accepted solution]

Hi @arjundelara 

The formula for that would be

DateTimeTrim(DateTimeParse([Month]+"-"+ToString(
DateTimeYear( DateTimeNow())),"%b-%Y"),"Lastofmonth")

Workflow:

Hope this helps 🙂

[arjundelara]

Great Workflow! Perfect.

Thank you @atcodedog05