Convert DateTime to Date

Hello To All

I have two variables DateTime and Date and i want to assign

Date:=DateTime;

How can i get just the Date portion from DateTime variable .

plz help me.

bye

Hi.

Why not use the same data type? Any major hindrance?

Try function DT2DATE

how to setrange datetime for “Today”?

You need to filter on ‘03/06/08 12:00 AM…03/06/08 11:59 PM’ setrange(“MYDateTimeField”,CREATEDATETIME(today,0000t),CREATEDATETIME(today,2359t));