SOLVED
=IF(C2="Complete", TEXT(A2,"YYYY")&"-"&TEXT(A2,"MM"),0)
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
Kinetic_analytics
11 - Bolide
‎12-09-2021
08:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How to convert =IF(C2="Complete", TEXT(A2,"YYYY")&"-"&TEXT(A2,"MM"),0) to Alteryx formula.
Solved! Go to Solution.
Labels:
- Labels:
- Date Time
1 REPLY 1
Matthew
11 - Bolide
‎12-09-2021
08:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
if
[ColumnC] = 'Complete'
then
tostring(DateTimeFormat([ColumnA],'%Y-%m'))
else
'0'
endif
![](/skins/images/0052A40480681DBBC707042CBFDD66A8/responsive_peak/images/icon_anonymous_message.png)