How can I automate to post monthly journal in the last day in a month

Learn Academy Feedback
1

Hi all,

Monthly, I have some transactions to allocate expense, posting date is always in the last day of a month, now I want to automate them, so could you help me to default posting date

Thanks in advance

2

Hi @HangTruong

Welcome to the community!! :smiley:

So, you need a way to get the last day of the month which you can add as the posting date right?

Cool, I have just the workflow you need to calculate the last day of the month. In this workflow, I have provided the current day in a variable named “CurrentDay”. You can change it according to test every month :slight_smile: This returns the last day of every month that you add to currentDay variable which is just the one you need…

Check it out…

GetLastDayOfMonth.xaml (5.2 KB)

If this works out for you, please also make sure to mark this answer as the solution too… :slight_smile:

Let know how it goes…

2 Likes
3

Hi @Lahiru.Fernando

Thanks a lot, I will try it :heart_eyes:

4

Hi @HangTruong

Let know whether it works for you once you try :slight_smile:

1 Like