You need to sign in to do that
Don't have an account?
Kushal Mishra
Formula field giving wrong TIME ZONE value
Hello All,
I have created following Two formula fields.
1:- CreateDateTImeBeforeOneHr1__c:-
TEXT((YEAR( DATEVALUE(CreatedDate))))+'-'+TEXT((MONTH( DATEVALUE(CreatedDate))))+'-'+TEXT((DAY( DATEVALUE(CreatedDate))))+' 12:00:00 AM'
OUTPUT1 :- 2015-11-7 12:00:00 AM
2:- CreateDateTImeBeforeOneHr__c:-
DATETIMEVALUE(CreateDateTImeBeforeOneHr1__c)
OUTPUT2 :- 11/7/2015 4:00 AM
i am getting wrong time zone .
Please can you please tell me How can we get 2015-11-7 12:00:00 AM in OUTPUT2.
I have created following Two formula fields.
1:- CreateDateTImeBeforeOneHr1__c:-
TEXT((YEAR( DATEVALUE(CreatedDate))))+'-'+TEXT((MONTH( DATEVALUE(CreatedDate))))+'-'+TEXT((DAY( DATEVALUE(CreatedDate))))+' 12:00:00 AM'
OUTPUT1 :- 2015-11-7 12:00:00 AM
2:- CreateDateTImeBeforeOneHr__c:-
DATETIMEVALUE(CreateDateTImeBeforeOneHr1__c)
OUTPUT2 :- 11/7/2015 4:00 AM
i am getting wrong time zone .
Please can you please tell me How can we get 2015-11-7 12:00:00 AM in OUTPUT2.
[1] https://help.salesforce.com/HTViewSolution?id=000181642