---
title: "Date Conversion"
canonical: "https://wiki.yellowfinbi.com/space/yfcurrent/2196935/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 (widget)


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](https://yellowfin.atlassian.net/wiki/download/attachments/2196935/campIncidents.csv?version=1&modificationDate=1479429902979&cacheVersion=1&api=v2).


## Example


### dd-MMM-yy

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

[Date Conversion#top](https://yellowfin.atlassian.net/wiki/spaces/yfcurrent/pages/2196935/Date+Conversion#DateConversion-top)