Page History
Anchor | ||||
---|---|---|---|---|
|
Table of Contents | ||
---|---|---|
|
Overview
Styleclass | ||
---|---|---|
| ||
2014-Aug-12
can be converted to 12/08/2014
.
HTML |
---|
<iframe width="700" height="394" src="https://www.youtube.com/embed/cOU9rQYfn4I?color=white" frameborder="0" allowfullscreen></iframe> |
In the example used here, we have a CSV file with two different date formats, and neither of them are recognised by Yellowfin as a standard date format. The CSV used can be located here.
Section | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Section | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Example
Styleclass | ||
---|---|---|
| ||
dd-MMM-yy
Section | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Section | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Section | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Section | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Section | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Section | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
dd/MM/yy
In this example, we are going to convert the End Date field. At the moment this field looks like a date Yellowfin should recognise, as it's in our default format of dd/MM/yyyy
, but Yellowfin actually needs to read in dates from the format yyyy/MM/dd
. So while it looks OK to us, Yellowfin has recognised it as text rather than a date.
Section | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Section | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
horizontalrule |
---|
Styleclass | ||
---|---|---|
| ||