topic Re: How can I get Year and Previous Month Name ? in Workato Pros Discussion Board

How can I get Year and Previous Month Name ?

dunncrew — Mon, 09 Dec 2024 20:32:55 GMT

I have a report that has data up to the end of previous calendar month. I want to email it, with the subject line saying "Report as of November 2024"

I can get December 2024 with this:

=today.in_time_zone("America/New_York").strftime(" %B %Y ")

But can't figure out how to subtract 1 month from it Where do I put "- 1.months" without a syntax error ?

Re: How can I get Year and Previous Month Name ?

shivakumara — Tue, 10 Dec 2024 05:41:01 GMT

Hi @dunncrew ,
As per the requirement you need always a month ago ( i.e. if current month December then requirement to get November). Please correct me.

in that case we can use directly "1.months.ago.in_time_zone("America/New_York").strftime(" %B %Y ")" to simply the solution.

Thanks and Regards,
Shivakumar K A

Re: How can I get Year and Previous Month Name ?

gary1 — Tue, 10 Dec 2024 05:19:37 GMT

To stick with your current formula you can do this:

=(today - 1.months).in_time_zone("America/New_York").strftime(" %B %Y ")

Re: How can I get Year and Previous Month Name ?

shivakumara — Tue, 10 Dec 2024 05:33:01 GMT

Hi @gary1 ,
Using (1.months.ago) instead of (today - 1.months) simplifies the solution.

Thanks and Regards,
Shivakumar K A

Re: How can I get Year and Previous Month Name ?

dunncrew — Tue, 10 Dec 2024 16:14:39 GMT

Thanks for both suggestions. At first it appeared your suggestions did not work.

I found a "bug" that if the variable was "DATE" type, changed to "STRING" , Workato remembers it used to be DATE and doesn't work, so I had to create new variables

Re: How can I get Year and Previous Month Name ?

gary1 — Tue, 10 Dec 2024 16:34:14 GMT

There's a difference between answering the question and providing the simplest solution. I answered the question.

Re: How can I get Year and Previous Month Name ?

bludwig62 — Fri, 13 Dec 2024 20:53:32 GMT

This is great!