Week to Date format
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Guys
I want to convert week to date (Last day of the Week) format.
can someone help pls>
regards
Rajesh
Solved! Go to Solution.
- Labels:
- Date Time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @RKGV
What's the logic? your numbers translate to these dates. Can you provide more clarity
Hope this helps : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @RKGV ,
some DateTime functions should do the job:
You should first split week number and year - for 1 digit weeks, add the leading "0".
Then calculate the first day of the year, which leads to the start of "week 1". For each week add 7 days and you should be done.
Let me know if it works for you.
Best,
Roland
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Oh, now it makes sense 😅 nicely done @RolandSchubert 🙂👍
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks. Works perfectly fine :)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello, this doesn't always seem to work. I found that starting in 2026, the results are off by a week. Thoutghs?