Datadate and Datatime to datetime

[hpl2001]

Hi:

I need to get the values of datadate and data time into one DateTime field. Does anyone know how this can be done?

Thanks.

Holly

 

[vidru]

Insert a text object, then drag in the Data Date field, hit the spacebar, then drag in the Data Time field.

-dave

 

[hpl2001]

Actually, I need to perform calculations on it. I need to calcualte the elapsed time between a datetime field in my database, and the datadate/datatime.

 

[mbarron]

You can create the datetime field by using:

datetime({date.field},{time.field})

Mike

 

[Madawc]

In Crystal 8.5, you should be able to 'bundle' them, something like
DateValue (datepart("yyyy", datadate),
datepart("m", datadate), datepart("d", datadate),
datepart("h", datatime), datepart("n", datatime))

This gives you year, month, day, hour and minute. You can then use 'DateDiff' to make comparisons, for hours it would be
DateDiff("h", @YourDate, otherdate)

Madawc Williams
East Anglia, Great Britain

 

[hpl2001]

Thank you all, that's so helpful. The datetime function was just what I was looking for!

Holly