Not applicable
2015-12-09
09:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Calander
Hi,
How to use Make date from this format--- 'Jan-2015'
or create this in the form of date Jan-2015 like 1/1/2015 for
Feb 2015 2/1/2015
like this for whole year
318 Views
2 Replies
sunny_talwar
MVP
2015-12-09
03:25 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this:
Table:
LOAD Date(A) as Date
FROM
[calander (1).xlsx]
(ooxml, no labels, table is Sheet1);
273 Views
maxgro
MVP
2015-12-09
03:30 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It seems you don't need any interpretation to get a date from your excel
LOAD
A,
Date(A, 'MMM-YYYY') as B
FROM
calander.xlsx
(ooxml, no labels, table is Sheet1);
273 Views