I need to first take out all of the time and just base it off of dates.

Then I need it to say:

If set up date AND breakdown date doesn't equal show date then "MULTI", or if set up date does not equal show date then "PRE" or if Breakdown date does not equal show date then "POST" otherwise "Single"

I tried this and it didn't work:

IF(AND(DATEPART(${Potentials.Set-Up date and time})!=Datepart(${Potential.Show Start}),DATEPART(${Potentials.Set-Up date and time})!=Datepart(${Potentials.Breakdown date and time}),'Multi',IF((DATEPART(${Potentials.Set-Up date and time})!=Datepart(${Potentials.Show Start}),'PRE',IF(Datepart(${Potentials.Breakdown date and time})!=Datepart(${Potentials.Show Start}),'Post','Single')))

An example would be:

Set up 1/1/2015 1:30 PM   Show Start 1/2/2015 3:00 PM  Break down 1/3/2015 3:00 PM  would return Multi

Set up 1/1/2015 1:30 PM   Show Start 1/2/2015 3:00 PM  Break down 1/2/2015 3:00 PM    would return PRE

Set up 1/1/2015 1:30 PM   Show Start 1/1/2015 3:00 PM  Break down 1/3/2015 3:00 PM   would return post

Set up 1/1/2015 1:30 PM   Show Start 1/1/2015 3:00 PM  Break down 1/1/2015 3:00 PM    Would return single

I am having it return as a string. Any suggestions?