Apex Code Development You need to sign in to do that
Don't have an account?
Linda 98 Datetime help
We are using professional org.
Having a process builder which updates a field on some condition with formula type.
this is how the formula is ,i am using & between them.
I am having datetime field which is used in the update field but the format is being changed
"Start Date:" & TEXT(DATETIMEVALUE([Opportunity].Date_Time_Start__c )) &
"End Date:" &TEXT([Opportunity].Date_Time_End__c ) &
This is the format i am lookinh for
2/27/2018 4:00 PM
but this is how i am getting
2017-02-27 21:00:00Z
How can i get this fixed??
Having a process builder which updates a field on some condition with formula type.
this is how the formula is ,i am using & between them.
I am having datetime field which is used in the update field but the format is being changed
"Start Date:" & TEXT(DATETIMEVALUE([Opportunity].Date_Time_Start__c )) &
"End Date:" &TEXT([Opportunity].Date_Time_End__c ) &
This is the format i am lookinh for
2/27/2018 4:00 PM
but this is how i am getting
2017-02-27 21:00:00Z
How can i get this fixed??
Linda, You might have better luck getting a good answer if you post this in the "Formulas & Validation Rules Discussion" topic instead of the "Apex Code Development" topic. As an Apex developer, I don't have much experience with formulas. The other topic will have more Advanced Admins looking at your question.
Linda 98Sure Thank you Glyn