You need to sign in to do that
Don't have an account?

Time Delay Issues
Hi All
I am using one custom object as Sample__c it contains three fields, the fields are:
1. Startdatetime__c(Date/Time datatype)
2. Value__c (Text)
3. NextDatetime__c(Date/Time datatype)----> Formulafield(Startdatetime__c+Value__c)-1
when am inserting any records in salesforce Startdatetime__c = 27/03/2014 04:00 , Value__c = 4 then the NextDatetime__c is 30/03/2014 05:00. Am assigning Startdatetime__c = 27/03/2014 04:00 but in NextDatetime__c is 30/03/2014 05:00 it increases 1hour also if the Nextdatetime__c is as 29/03/14 04:00 it shows a correct time format from Startdatetime__c. If the date goes to 30th day and above means the time increases by 1hour , if the date is in same month like 29 below means it shows the correct time format.... Is there any other way to solve this?
Organization timezone & User timezone are same GMT+00:00 (Europe/London)
Thanks
Venkatsforce
I am using one custom object as Sample__c it contains three fields, the fields are:
1. Startdatetime__c(Date/Time datatype)
2. Value__c (Text)
3. NextDatetime__c(Date/Time datatype)----> Formulafield(Startdatetime__c+Value__c)-1
when am inserting any records in salesforce Startdatetime__c = 27/03/2014 04:00 , Value__c = 4 then the NextDatetime__c is 30/03/2014 05:00. Am assigning Startdatetime__c = 27/03/2014 04:00 but in NextDatetime__c is 30/03/2014 05:00 it increases 1hour also if the Nextdatetime__c is as 29/03/14 04:00 it shows a correct time format from Startdatetime__c. If the date goes to 30th day and above means the time increases by 1hour , if the date is in same month like 29 below means it shows the correct time format.... Is there any other way to solve this?
Organization timezone & User timezone are same GMT+00:00 (Europe/London)
Thanks
Venkatsforce
See the link below for more information,
http://help.salesforce.com/help/pdfs/en/formula_date_time_tipsheet.pdf
Regards,
Ashish