4 Replies Latest reply on Aug 16, 2011 1:33 PM by JantzSelk

    Keeping Date Formatting within a calculation



      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!