I have a formula that is giving me the Error "A DateTime field is Required". I have tried many different variations of the formula and I don't have a solution. I was wondering if anyone has any ideas.
Using Crystal Reports 2016, Database location is an Access Database Query.
The fields in question are:
_Query.Received_Date - DateTime format
_Query.Received_Time - String Format
I created a formula @RVCDDateTime
{......_Query.Received_Date}&" "&ctime(toNumber(left({....._Query.Time},2)),tonumber(right({......_Query.Time},2)),0)
the formula above works.
Created a new Formula - "@Turnaround"
DateTimeVar startdate := {@RCVDDateTime};
when you perform a Formula check I get the message A DateTime field is required.
when you hover your mouse over the @RVCDDateTime formula is shows as a string. I'm assuming because it shows up as a string that is why I get the error message. Any and all Suggestions are appreciated.