Date Conversion
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
My excel date shows like this format.
But when I run it in Alteryx it shows like this in VWString format.
Tried using the date tool but it gives me a NULL value. Can someone help me please on how to convert it this type of format
Attaching excel for your reference.
Thanks,
Kamen
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Kamen,
You'll need to convert your input to a Datetime data type to preserve the incoming date format. You can do this using a Select Tool.
Hope this helps.
__PRESENT
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hi @KamenRider .. your file is in xlsx and when i download it it shows me YYYY-MM-DD part of your data in alteryx.. however.. the format changing when fed to alteryx we had that.. i change the file from xlsx to csv... not sure if it will work for you but worth the shot. goodluck!! :)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for your response however, converting it to csv is not a requirement. It should be in xlsx format.
Kamen
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@KamenRider check your other expressions. That error is linked to your first expression as stated - you're not using a '+' and don't have 50 characters in the expression you're showing.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @DataNath
I'm sorry but I can't the reason of the error. I don't special characters in the formula and I am a kind of confuses why using + sign.
Please advise.
Kamen
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@KamenRider can you show your full screen including all expressions etc?