AnsweredAssumed Answered

Keeping Date Formatting within a calculation

Question asked by JantzSelk on Aug 16, 2011
Latest reply on Aug 16, 2011 by JantzSelk


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!