Hi,
Please help me to convert the date 2020-12-25 to Dec-2020. I want the output ( Dec-2020 ) in Date format not in String format.
I tried formula and Date parse tool. I couldn't get the desired output.
Kindly help me.
Thanks,
Kishore
@Falcon8273 — Suggest you to go with your Date as they look in Alteryx's Date Format, do whatever you want to (Sort/Filter/CrossTab etc.), then once you think that the output is good for you, then simply convert that Date Field into your "MMM-YYY" format, and de-select(drop) the actual date format; keep new field.
@Falcon8273 - Thank You!
Hi @Falcon8273 — Alteryx has standard date format in YYYY-MM-DD only, and you can convert into the desired format, then data type will be String.
Example:
%b-%Y
An alteryx Date field is always stored in YYYY-MM-DD format
If you want to have a filed in Mon-YYYY format it will need to be a string field (or one of the variants)
A formula tool with expression:
DateTimeFormat([Date],"%b-%Y")
should produce what you want
Hi @Falcon8273 , you can only have date time or date format by using the default date format yyyy-mm-dd as alteryx support only this format as default date.If you try to convert it to a custom format
this is the warning you get.
In short if you want to convert it into DEC-2020 format this will be output as string.
Thanks.
Hi @vizAlter - I need the output format as Date and not string.
thanks
Below is my data with date and sales. Where I try to convert the date to String - Mon YYYY. In cross tab tool. I am not able to get the output in Old to new date format order. Cross tab tool is arranging the Month in ascending or Descending order basis the first alphabet but not able to read the string as date.
2020-01-20
8100
2019-08-19
Desired Output - Create a Cross tab to arrange the table in Past to present month order as below without manually changing the row.
Aug 2019
7800
Feb 2020
Hi @Falcon8273 ,
Can you attach a workflow so that its more clear.
