6 Replies Latest reply on Mar 5, 2013 9:31 PM by Prashant Sharma

    Change date format according to condition

    Prashant Sharma

      Hi,

       

      I have one date field which is in two different formats(Formats are "dd.mm.yyyy"(this is in string format) & "yyyy/mm/dd" (this is in date format) in database). Now i wanted to change the date format to "mm/dd/yyyy" for both the values but when i changed the date format for 08.01.2011(dd.mm.yyyy) then it gives 08/01/2011(mm/dd/yyyy) which is wrong as i want 01/08/2011.

      How to do this?

      Thanks in Advance!!