We have requirement for a custom field MS Created Date having data type as date/Time. I loaded the field using data loader. But the date is getting loaded correctly but the time is not get loaded properly. For eg. If i load date/ time through dataloader as 04/10/2006 09:40:40:000 (dd/mm/yyyy hh:mm:ss:SSS format ), but in the sfdc it is getting loaded as 04/10/2006 06:10(dd/mm/yyyy hh:mm:ss:SSS format) so there is a 3 hour 30 minute difference is there. Using data loader i used the format as yyyy-MM-dd'T'HH:mm:ss.SSS'Z' format. I tried all the format which are given in the dataloader document as shown below. •yyyy-MM-dd'T'HH:mm:ss.SSS Pacific Standard Time • yyyy-MM-dd'T'HH:mm:ss.SSSPacific Standard Time • yyyy-MM-dd'T'HH:mm:ss.SSS PST • yyyy-MM-dd'T'HH:mm:ss.SSSPST • yyyy-MM-dd'T'HH:mm:ss.SSS GMT-08:00 • yyyy-MM-dd'T'HH:mm:ss.SSSGMT-08:00 • yyyy-MM-dd'T'HH:mm:ss.SSS -800 • yyyy-MM-dd'T'HH:mm:ss.SSS-800 • yyyy-MM-dd'T'HH:mm:ss • yyyy-MM-dd HH:mm:ss • yyyyMMdd'T'HH:mm:ss
But also I am getting the same incorrect value with no change in the time. I am using the Time Zone as "GMT+01:00) Central European Time (Europe/Paris)" in SFDC and my computer time zone is GMT +5:30. Please help me to resolve the problem. Thanks in advance for your solution.
We have a requirement that to open a file by clicking the File Path. We created a custom field Path for the File Path by giving data type as URL. While saving the file path is prefixed with "http://" so that the file is not opening.
For example the server path is "\\pt-s-fsmira-01\" and the file present in it having name as "test.doc". So the path is "\\pt-s-fsmira-01\test.doc". I place the path by creating custom field PATH having data type as URL. I want to open the file by clicking the path "\\pt-s-fsmira-01\test.doc". But the problem is i gave the data type URL.So the file path is automatically prefixed with "http://" so the file is not opening but giving an error invalid address.
Hi , Can we update the Probability% field in opportunity based on a Formula or with a Field Update. I tried it , but its not working. Any kind of pointers would help me.
We have a requirement that to open a file by clicking the File Path. We created a custom field Path for the File Path by giving data type as URL. While saving the file path is prefixed with "http://" so that the file is not opening.
For example the server path is "\\pt-s-fsmira-01\" and the file present in it having name as "test.doc". So the path is "\\pt-s-fsmira-01\test.doc". I place the path by creating custom field PATH having data type as URL. I want to open the file by clicking the path "\\pt-s-fsmira-01\test.doc". But the problem is i gave the data type URL.So the file path is automatically prefixed with "http://" so the file is not opening but giving an error invalid address.
