
Partner - Creator III
2016-11-13
01:24 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
CONVERT DATA YYYYMMDD DD/MM/YYYY
Hi,
how to convert a date in yyyymmdd to format dd / mm / yyyy
example:
Date: 20161101 (YYYYMMGG)
to
Date: 01/11/2016
and viceversa.
From date: DD/MM/YYYY
To date: YYYYMMDD
3 Replies

MVP
2016-11-13
01:43 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try some of this
Date(Date#(20161101,'YYYYMMDD'),'DD/MM/YYYY')
Or
Date(Date#(DateField,'YYYYMMDD'),'DD/MM/YYYY')
Or
Date(20161101,'DD/MM/YYYY')
Or
Date(DateField,'DD/MM/YYYY')
Regards
Anand

MVP
2016-11-13
01:51 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please find the attached one with any date field how to do this also please assure you have proper date field
LOAD * ,Date(Date#(DateField,'YYYYMMDD'),'DD/MM/YYYY') as FormatedField;
LOAD * Inline
[
DateField
20161101
];
If you have proper date field then use this
LOAD
*
Date(DateField,'DD/MM/YYYY') as FormatedField
From Location;
Regards
Anand

MVP
2016-11-13
03:06 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
you can find a lot of usefule info on date conversion here
and in this pdf
