Challenge #367: Manipulating Dates – End of the Month
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
robbinrv
8 - Asteroid
04-17-2023
09:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Did it in a round about way before figuring out an quicker solution
Spoiler
would recommend the datetimetrim "lastofmonth" option instead :)
gerda
8 - Asteroid
04-17-2023
10:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here's the solution!
TurboToad
11 - Bolide
04-17-2023
10:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Nice new DT function to learn about.
Spoiler
datetimeformat(DateTimeTrim(DateTimeParse([Date],'%m/%d/%Y'),'lastofmonth'),'%m/%d/%Y')
Arjunmarwaha09
8 - Asteroid
04-17-2023
10:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Challenge #367 Done
ggruccio
ACE Emeritus
04-17-2023
10:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Not all the expected results are month ends --- for instance, 8-30 is not the end of August...should be 8-31...but other than that, fun challenge.
Asmaa-jirani
5 - Atom
04-17-2023
11:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
CharlotteGuy
8 - Asteroid
04-17-2023
12:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
mmontgomery
11 - Bolide
04-17-2023
12:38 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Tried to do it all in one formula tool
Clifford_Coon
11 - Bolide
04-17-2023
12:42 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My Solution
Spoiler
Already had created macro to do this:
nSpire
9 - Comet
04-17-2023
01:20 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator