Separating Timestamp

[CindyG]

Hi!

Can someone please tell me how I can separate a timestamp? All I need is
the Date and I can't figure out how to do that. There are about 330,000 rows
in my database. I have tried running a query and changing the format into a
Date and that does not work. Any suggestions??? Thanks

Cindy

 

[Rick B]

You can use the format option to display on ly the date in your queries,
reports, or forms.

For a form or report...
=Format([Timestamp],"Long Date")

For a query...
TimestampDate: Format([Timestamp],"LongDate")


Rick B

 

[CindyG]

Thank you so much. That worked!!!!

You can use the format option to display on ly the date in your queries,
reports, or forms.

For a form or report...
=Format([Timestamp],"Long Date")

For a query...
TimestampDate: Format([Timestamp],"LongDate")


Rick B

Hi!

Can someone please tell me how I can separate a timestamp? All I need is
the Date and I can't figure out how to do that. There are about 330,000 rows
in my database. I have tried running a query and changing the format into a
Date and that does not work. Any suggestions??? Thanks

Cindy

 

[Douglas J. Steele]

Recognize, though, that all you're doing there is changing the presentation:
the underlying value is unchanged. If all you want is just the date value or
just the time value, you may be better off using the DateValue and TimeValue
functions.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

You can use the format option to display on ly the date in your queries,
reports, or forms.

For a form or report...
=Format([Timestamp],"Long Date")

For a query...
TimestampDate: Format([Timestamp],"LongDate")


Rick B

Hi!

Can someone please tell me how I can separate a timestamp? All I need is
the Date and I can't figure out how to do that. There are about 330,000 rows
in my database. I have tried running a query and changing the format
into a
Date and that does not work. Any suggestions??? Thanks

Cindy