Hi ,

Can anyone tell me the formula for Text type formula field to extract Time from DateTime field. I tried few ways but not getting the correct result.

User's TimeZone -  (GMT-07:00) Pacific Daylight Time (America/Los_Angeles)

Ex -  Start DateTime 4/25/2020, 4:00 PM , End DateTime -4/25/2020, 8:30 PM
Desired result : 4:00 PM - 8.30 PM

TIA.

 

Hi all,

I've UTC time zone in String type want to insert in SF but facing conversion issue. Can anyone help me out.

Ex. String utcTime='2018-05-03T16:52:23Z'

Want to convert this string into DateTime so i can insert into SF.

TIA

Hi,
I'm trying to make rest callout with Patch method. But  Sf does not supports Patch method. Is there any Alternative or solution to Achieve this.

Tried Solutions : 1. Appending with endpoint ?_HttpMethod = POST
2. req.setHeader('X-HTTP-Method-Override','PATCH') 

TIA

Hi all,
Can anyone tell me how to convert Excel file to Csv file into apex ?

TIA

Hi ,

Can anyone tell me the formula for Text type formula field to extract Time from DateTime field. I tried few ways but not getting the correct result.

User's TimeZone -  (GMT-07:00) Pacific Daylight Time (America/Los_Angeles)

Ex -  Start DateTime 4/25/2020, 4:00 PM , End DateTime -4/25/2020, 8:30 PM
Desired result : 4:00 PM - 8.30 PM

TIA.