Sometimes there is a real date and the user may want it customized to some special string format. The following is one way to use a calculated field to pull each date part out of the original value and present it.

// BEGINNING OF CALCULATED FIELD

// Format the date into a nice string ’01/01/2017′ or ‘ ‘ if NULL

IF ISNULL([LoanApplicationDate]) THEN ‘ ‘
// Source Format 1/1/2017 Length(m,d,y) = (1,1,4)
ELSEIF LEN(STR(DATEPART(‘month’, [LoanApplicationDate]))) = 1
AND LEN(STR(DATEPART(‘day’, [LoanApplicationDate]))) = 1
THEN ‘0’ +
STR(DATEPART(‘month’, [LoanApplicationDate])) + ‘/0’ +
STR(DATEPART(‘day’, [LoanApplicationDate])) + ‘/’ +
STR(DATEPART(‘year’, [LoanApplicationDate]))
// Source Format 10/1/2017 Length(m,d,y) = (2,1,4)
ELSEIF LEN(STR(DATEPART(‘month’, [LoanApplicationDate]))) = 2
AND LEN(STR(DATEPART(‘day’, [LoanApplicationDate]))) = 1
THEN
STR(DATEPART(‘month’, [LoanApplicationDate])) + ‘/0’ +
STR(DATEPART(‘day’, [LoanApplicationDate])) + ‘/’ +
STR(DATEPART(‘year’, [LoanApplicationDate]))
// Source Format 1/12/2017 Length(m,d,y) = (1,2,4)
ELSEIF LEN(STR(DATEPART(‘month’, [LoanApplicationDate]))) = 1
AND LEN(STR(DATEPART(‘day’, [LoanApplicationDate]))) = 2
THEN ‘0’ +
STR(DATEPART(‘month’, [LoanApplicationDate])) + ‘/’ +
STR(DATEPART(‘day’, [LoanApplicationDate])) + ‘/’ +
STR(DATEPART(‘year’, [LoanApplicationDate]))
// Source Format 12/12/2017 Length(m,d,y) = (2,2,4)
ELSEIF LEN(STR(DATEPART(‘month’, [LoanApplicationDate]))) = 2
AND LEN(STR(DATEPART(‘day’, [LoanApplicationDate]))) = 2
THEN
STR(DATEPART(‘month’, [LoanApplicationDate])) + ‘/’ +
STR(DATEPART(‘day’, [LoanApplicationDate])) + ‘/’ +
STR(DATEPART(‘year’, [LoanApplicationDate]))
END

// END OF CALCULATED FIELD