Keeping Date Formatting within a calculation
I have a calculation that in part uses a date field (DateCreated); the relevant calculation portion looks like Upper(abr& Substitute ( ( DatePrepared ) ; "-" ; ""))
The "DateCreated" field is formatted to display the date as mm/dd/yyyy. Unfortunately when i use this date field in a calculation it loses this custom formatting and reverts back to the files default date format yyyy-mm-dd (without the "-")
Anyone know how i can keep the date fields formatting within the calculation, or alternatively format the date within the calculation to look like mm/dd/yy (without the "/")?
Any help is appreciated!