---
title: "Date Conversion"
canonical: "https://wiki.yellowfinbi.com/space/USER72/2833342/Date%20Conversion"
format: markdown
---
> Macro (anchor)



> Macro (toc)

## Overview

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`.

 

> Macro (html-bobswift)

 


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 .

> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)

> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)

## Example


### dd-MMM-yy

> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)

> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)

> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)

> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)

> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)

> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)

### 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.

> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)

> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)