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

Error rendering macro 'rw-search'

null

Versions Compared

Old Version 1

changes.mady.by.user Yellowfin

Saved on

compared with

New Version 2

changes.mady.by.user Yellowfin

Saved on

Key

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

...

Section
Column
width30%

You will now have a new field at the end of your CSV table. This will have an orange band at the top to identify it as a converted field.

Column
width70%

dd/MM/yyyy

...

width30%

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
Column
width30%

1. Click the New Function button, select Date Conversion and choose the End Date field.

2. Click Create to begin*.

3. Complete the Name and Converted Date Type as before.

4. If you were not sure how to specify your date format, i.e. what characters to use in the Date Format field, click on the (info) symbol in the field.

Column
width70%

...