My Scenario is, I am having two fields as Startdatetime_c(date/time) & LastDatetime(date/time). Here another one field Nextdatetime_c(date/time Formula field) i want the Date from LastDatetime_c(date/time) and time from Startdatetime_c(date/time).I tried the following:
DATEVALUE(LastDatetime__c) & TIMEVALUE(Startdatetime__c)
But it throws the error as Error:
Unknown function TIMEVALUE. Check spelling.
How to resolve this?