I have  report that pulls the birth date for a student, but pulls the date and time. I need to be able to display the report, but just want to display the date and not the time. I have tried

if length(undergrad.birtdate)<39 then {undergrad.birtdate} else

left(undergrad.birtdate,instrrev(left(undergrad.birtdate,39),' ')-1)

but get an error stating expecting string. Not sure where to try next on this. Any help would be appreciated. I need to truncate to 39 characters (which in most situations this would happen automatically, but just trying to cover my a$$ with the formula)

Thanks

Kevin

That works great for showing in the report, but I have a report "header" piece that has the birth date filed as part of a formula that I can not edit like this. I need to just display that date format as part of the formula. Here is the entire formula for reference

"|"&"Admissions"&"|"&{ContactExtensionBase.Datatel_erpid}&"|"&{@lastnametrunc}&"|"&{@firstmiddletrunc}&"|"&{datatel_undergraduateapplicationforadmissionExtensionBase.Datatel_birthdate}&"|"&{datatel_undergraduateapplicationforadmissionExtensionBase.H17_AreyouaUSCitizen}&"|"&{@counselortrunc}&"|"&{@termidformtrunc}&"||"&"App -"&" "&{@admittypeformtrunc}&" "&{@decisionplanformtrunc}&"|"

It is being used by a separate program for indexing purposes.  DOB is in red.

Thanks
Kevin

Thanks - exactly what I was looking for.