Challenge #359: Manipulating Dates
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
nSpire
9 - Comet
02-20-2023
11:26 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
lvprasad
7 - Meteor
02-20-2023
11:48 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Watermark
12 - Quasar
02-20-2023
11:50 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
RWvanLeeuwen
11 - Bolide
02-21-2023
12:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Christina_H
14 - Magnetar
02-21-2023
12:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Sebastian_Chaieb2
10 - Fireball
02-21-2023
01:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
One tool solution
Chia
5 - Atom
02-21-2023
01:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
willemb
7 - Meteor
02-21-2023
02:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
ASTHA1111
5 - Atom
02-21-2023
03:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Below is the solution for the above challenge in which I have created a formula for changing the date field in the above specified challenge the formula for which is given below.
IF
tonumber(right([Date],findstring([Date],"/"))) < 4 then "Q1 "
elseif
tonumber(right([Date],findstring([Date],"/"))) < 7 then "Q2 "
elseif
tonumber(right([Date],findstring([Date],"/"))) < 10 then "Q3 "
else "Q4 "
endif
garvit96
5 - Atom
02-21-2023
05:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator