Skip to Content
0
Sep 12, 2023 at 10:11 AM

A DateTime is Required Error Message

76 Views

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.