Convert text to Date/time
Could anyone tell if it is possible to convert text field
Appoitment D is Text field, using for date
Appoitment T is Text field, using for time
Appoitment Date/Time is formula field return type of Date/TIme
Formula is DATETIMEVALUE(Appoitment_D__c +" "+ Appoitment_D__c+':00')
But getting error!
Appoitment_D__c + " " + Appoitment_D__c + ":00"What do you see printed on the page ?
You should be writing -
DATETIMEVALUE(Appoitment_D__c + " " + Appoitment_T__c + ":00")
Oh! My blunder But now it's calculating wrong Idon't know why
I have entered Appotiment date = 04/15/2018 and Appoitment Time =3:10 Pm