Like what you see? Have a play with our trial version.

Error rendering macro 'rw-search'

null

Versions Compared

Old Version 6

changes.mady.by.user Yellowfin

Saved on

compared with

New Version 7

changes.mady.by.user Yellowfin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
top
top

Table of Contents
classcontents

Overview

Styleclass
ClasstopLink

top

The Date Conversion function is available during the CSV Import process. It allows you to convert date fields that are unconventionally formatted, into a standard date format that Yellowfin can recognise. For example, a date stored in your CSV as 2014-Aug-12 can be converted to 12/08/2014.

...

Section
Column
width30%

The Date fields, Start Date and End Date, are shown in the file, but Yellowfin has recognised them as Varchar (text) fields, as they were not formatted in the standard date format.

Column
width70%

Example

Styleclass
ClasstopLink

top

dd-MMM-yy

Section
Column
width30%

1. Click on the New Function button on the left of the CSV Data page. This will open a menu displaying all the functions that can be built into your file.

Note: this screenshot is from the Report Builder CSV Import, if using the View Builder CSV Import not all of these options will be available, as they are available in later stages of the standard View Builder process instead.

Column
width70%

...

Section
Column
width30%

5. From here you will be shown what character combinations make up what date components. Work out which characters you need and click Close to return to the previous screen.

6. Enter dd/MM/yy and click Save to complete.

Column
width70%

 

horizontalrule
Styleclass
ClasstopLink

top