Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Date formula

Prajwal19
6 - Meteoroid
‎09-22-2020 04:36 AM

Hi,

 

I have dates in column A, I want know a formual wherein if the dates are in 2019 then the output should be 2019. If the dates are in 2020 then the output should be their respective month. 

 

Prajwal19_0-1600774484202.png

 

Preview file
10 KB
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
BrianR
Alteryx
Alteryx
‎09-22-2020 04:49 AM

Hi @Prajwal19, you can place a Formula tool right after your data, and then you can transform it with this Formula:

 

BrianR_0-1600775373047.png

 

Reply
vizAlter
12 - Quasar
‎09-22-2020 05:50 AM

Hi @Prajwal19 —  Try this solution too... you can achieve the result without using a Formula tool as well:

 

vizAlter_0-1600779026047.png

 

Please mark it "Solved" or "Solved" with a Like if it resolved your query. This will help other users find the same answer/resolution.  Thank you.

Preview file
9 KB
Date Formula without Formula tool.yxmd
Date Formula without Formula tool.yxzp
Reply
connect with mentors
designer new user guide
Labels
Top Solution Authors
View All