Covering excel Number to the date format
- 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 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
Solved! Go to Solution.
- Labels:
- Data Investigation
- 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,
Tried to implement the same but somehow getting an error message
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Kavya432 is your Course_Date field a string it would need to be a numeric field you could use a select and change the field type or us ToNumber([Course)_Date]) in your formula.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you
It works with number but not with date. The first screenshot if you see it has combination of number and date. For number its working fine but for date its not. Any idea should be appreciated.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks Joseph! Its worked!
