Link to home
Start Free TrialLog in
Avatar of kelsanit
kelsanit

asked on

Crystal Datetime to and from query

I have the following query i can not get to work.

{CurrentAssetReadings.ReadingDateUTC} in DateTime ({FiscalPeriods.BeginDate}, 00, 00, 00) to DateTime (currentdate, 06, 00, 00)
Avatar of Mike McCracken
Mike McCracken

What isn't working?

Where is that?
Is it in the Record Selection?

What data is in the field?

mlmcc
Avatar of kelsanit

ASKER

using the following formula and get "A time is required here" for this part of the formula DateTime (currentdate, 06, 01, 00)

Using this in a running total evluate section

{CurrentAssetReadings.ReadingDateUTC} in Date ({FiscalPeriods.BeginDate}) to DateTime (currentdate, 06, 01, 00)
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial