- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Date
Hi Experts,
I am getting data source files date in this format " 12/12/2015 9:00:00 AM " but going forward I will get date format like " 12/12/2015 9:00:00 09" in place of "AM" I will get some number. Anyhow am not using time part in my dashboard. But if they change date format will it impact my current dashboard? Please Suggest me
Thank You
- Tags:
- date calendar
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
If you are not using Time part then try like below
LOAD
Date(Date#(Left(FieldName, 10), 'MM/DD/YYYY'), 'DD-MMM-YYYY') as Date,
,
,
FROM DataSource;
Regards,
jagan.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be truncate the time part:
Date(Date#(Left(TimeStampField, 10), 'MM/DD/YYYY')) as Date
Assuming your date format is MM/DD/YYYY
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Sunny,
I am loading data in this format
Date(Floor(Date#(Extraction_Date, 'YYYY-MM-DD hh:mm:ss TT'))) AS ExtractionDate. But in Dashboard am using 'DD-MMM-YYYY' format. If they change in data source will it impact to Dashboard? Now in data source they were planning to add some number in place of "AM & PM "
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Jack,
Suppose if you are getting the format "12/12/2015 9:00:00 09", your mentioned statement won't work. May be you can change your statement as suggested by sunny.
or you can try this too.
=Date(Floor(Date#(SubField('2015-12-12 9:00:00 09',' ',1),'YYYY-MM-DD')))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sorry,
My Date format is now " 12/12/2015 9:00:00 AM " in AM & PM format. Going forward it will change to 24 hour format no more AM & PM in Date.
For example: Time Part
09:30 AM to 09:30
01:25 PM to 13:25
11:59 PM to 23:59
So this changes will impact my current dashboard?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
If you are not using Time part then try like below
LOAD
Date(Date#(Left(FieldName, 10), 'MM/DD/YYYY'), 'DD-MMM-YYYY') as Date,
,
,
FROM DataSource;
Regards,
jagan.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes this will impact. If you are not using Time part then use like below
LOAD
Date(Date#(Left(FieldName, 10), 'MM/DD/YYYY'), 'DD-MMM-YYYY') as Date,
Regards,
Jagan.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank You All