Print Page | Close Window

Add Time to a Variable Date

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20765
Printed Date: 03 May 2024 at 1:43am


Topic: Add Time to a Variable Date
Posted By: JessicaQ
Subject: Add Time to a Variable Date
Date Posted: 27 May 2014 at 9:43am
I need to identify a specific time, but not a specific date. My goal is to say, at midnight on "this date" the patient was at this location.
"This date" = minimum(lastfullmonth)+1

I get 4/2/2014 for my date, but I need to add the midnight time frame and be able to calculate on it.

I was using this formula for the entire date but they want to know exactly at midnight where the patient was:
{@Start} <= minimum(lastfullmonth)+1
   and
{@End} >= minimum(lastfullmonth)+1

Any help would be great.


Replies:
Posted By: DBlank
Date Posted: 28 May 2014 at 4:35am
maybe
datetime(minimum(lastfullmonth)+1 ) in mailto:%7b@Start - {@Start } to mailto:%7b@End - {@End }


Print Page | Close Window