You need to sign in to do that
Don't have an account?
SFDC Admin 56
Converted a text field to a date field, its updating fine in page layout but showing error(on column) in report.
This is a formulae filed and Cornerstone_Created_Date is a text field of 1/1/2017 12:00:00 AM format. on page layout its showing exactly what i want but in reports, when i try to enter this column, its showing me error on all the records.
DATETIMEVALUE(
/* get the year */
RIGHT(LEFT(Cornerstone_Created_Date__c, FIND(" ", Cornerstone_Created_Date__c ) - 1), 4)
& "-" &
/* get the month */
LEFT(Cornerstone_Created_Date__c , FIND("/", Cornerstone_Created_Date__c ) - 1)
& "-" &
/* get the day */
LEFT(
MID(Cornerstone_Created_Date__c, FIND("/", Cornerstone_Created_Date__c ) + 1, 4),
FIND("/", MID(Cornerstone_Created_Date__c , FIND("/", Cornerstone_Created_Date__c) + 1, 4)) - 1
)
& " " &
/* get the Time */
MID(Cornerstone_Created_Date__c,
FIND(" ", Cornerstone_Created_Date__c ),
LEN(Cornerstone_Created_Date__c ) - FIND(" ",Cornerstone_Created_Date__c ) + 1
)
)
DATETIMEVALUE(
/* get the year */
RIGHT(LEFT(Cornerstone_Created_Date__c, FIND(" ", Cornerstone_Created_Date__c ) - 1), 4)
& "-" &
/* get the month */
LEFT(Cornerstone_Created_Date__c , FIND("/", Cornerstone_Created_Date__c ) - 1)
& "-" &
/* get the day */
LEFT(
MID(Cornerstone_Created_Date__c, FIND("/", Cornerstone_Created_Date__c ) + 1, 4),
FIND("/", MID(Cornerstone_Created_Date__c , FIND("/", Cornerstone_Created_Date__c) + 1, 4)) - 1
)
& " " &
/* get the Time */
MID(Cornerstone_Created_Date__c,
FIND(" ", Cornerstone_Created_Date__c ),
LEN(Cornerstone_Created_Date__c ) - FIND(" ",Cornerstone_Created_Date__c ) + 1
)
)