SOLVED
How to find the start of the quarter date from quarter in alteryx
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
haya
8 - Asteroid
‎11-14-2017
12:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Team ,
I have a filed called achievement quarter with value as "20174" how do I generate a field date with value "10/01/2017" from the existing field achievement quarter.
Any help would be much appreciated.
Regards,
Haya
Solved! Go to Solution.
Labels:
- Labels:
- Preparation
2 REPLIES 2
jdunkerley79
ACE Emeritus
‎11-14-2017
01:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
A formula tool with expression like :
SWITCH(MOD([YearQtr],10), NULL(), 1, "01", 2, "04", 3, "07", 4, "10") + "/01/" + ToString([YearQtr]/10, 0)
should give you what you want.
If you want a real Alteryx date then:
ToString([YearQtr]/10, 0) +
SWITCH(MOD([YearQtr],10), NULL(), 1, "-01", 2, "-04", 3, "-07", 4, "-10") + "-01"
Sample attached
‎11-14-2017
02:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanksalot :)