Working with Date/Time Fields

[SherriKilgore]

How can I convert a Date/Time field into a Date field?

 

[plog]

Huh? A date/time field is a date field.

Going to use my superhuman intuition powers to guess you just want to display the date portion. For that you would use the Format function (http://www.techonthenet.com/access/functions/date/format.php).

 

[SherriKilgore]

I tried this but I need to be able to ignore the time portion of the date/time field. I can create a work around, was just hoping it was something simple I was over looking. Thanks for your help.

 

[bob fitz]

I tried this but I need to be able to ignore the time portion of the date/time field. I can create a work around, was just hoping it was something simple I was over looking. Thanks for your help.

Can you not get the Format() function to return just the date?
What is the "work around" that you have created?

 

[Galaxiom]

Can you not get the Format() function to return just the date?

The Format function returns a string rather than a Date.

DateValue() is a better choice. It returns the date without the time and works with any date/time expression or valid date/time string as input.