Java Script

I need a java script to add to flow that capture the previous Sunday of the current week. Example, if the current date is Friday, I would need the last Sunday date.

Thanks

Gary

Find more posts tagged with

Process Automation (IPA) - General Discussions

Accepted answers

All comments

jreese

Determine the current day of the week, currDate.getDay(), and then use the AddDay() function to get the previous Sunday.

In you example assign a variable to the value today() like TodaysDate. Then use the function tempday = TodaysDate.getDay(), which would get you the value of 5. Sunday = 0, Monday = 1, etc. Finally use AddDay(TodaysDate, -tempday) to get the previous Sunday.

unknown

FYI, sql has a lot of very nice date math and formatting functions that you can use as well. Here are a couple of links you can use to start to dig into them:

Date function reference: docs.microsoft.com/.../date-and-time-data-types-and-functions-transact-sql

Cast and convert functions reference (use convert for date formatting): docs.microsoft.com/.../cast-and-convert-transact-sql

I use an sql node with an assign node inside it to create and format any dates I need and assign them to variables for use later in the flow.

Copyright © 2025 Infor. All rights reserved.