SOLVED
Generate two weeks from current date but should always ends on friday
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Ultralightbeam
8 - Asteroid
‎01-25-2021
05:36 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If the date is January 18 2021 it should generate two weeks of dates from January 18 2021 to January 29 2021 and if it is January 29 2021 it still should generate the previous week of January 18 2021 to January 29 2021. it's like rounding off to the nearest friday every two weeks of time.
Initially it should generate a rows from January 18 to 29 (always monday to friday next week ) and whatever the current date is it should always fall to 18 to 29 as long as it's within its range
With current date today 26th of January, it should generate from the monday of the 26th of january which is 25 up to the next friday 5th of February.
Solved! Go to Solution.
Labels:
- Labels:
- Transformation
1 REPLY 1
21 - Polaris
‎01-25-2021
07:04 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
