+ Start a Discussion

Adjustment of Date and Time Values at Opportunity Object

I have 2 custom fields in the opportunity like Start date and End date
The format for them is Start Date:-  10/20/2010 10.59PM
                               End Date :-    11/31/2010   10:59 PM
The time will be set automatically whatever the time the system shows.


Now, the requirement is that  Star Date : Any date  12:01AM and End date : Any Date 11:59 PM.


So the time should be displayed like that no matter what ever the created date and time and it is for every oppotunity.


Is it possible  to do write any formula field or trigger, please help me on this?


You can create text formula field to get the value. Ex


TEXT(CloseDate) & " " & "12:01 AM"