Hi Team,
I have Number and need to convert it as Date format. In Excel that number is showing as date.
Is there any formula or tool I need to use to convert it.
Thanks Kavya
Hi @Kavya432 I would have a filter looking for date formats one idea could be contains "-" then everything that doesn't have a "-" then apply that formula to convert to date then use a union tools to bring your data back together.
Hi @Kavya432 you might find this post helpful where @JordanB has built a workflow that solves this.
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-convert-the-Excel-numerical-date-to-date-in-Alteryx/td-p/11184
Thanks,
Tried to implement the same but somehow getting an error message
