Exporting the Date without the time

[Guest]

I am trying to reformat a date/time field to export it without the time.
Article 291245 gives a suggestion (Method 1), but I can not figure out how to
implement the suggestion. Can not figure out how to do a new calculated
field with the suggested format.

Any help would be greatly appreciated. Thanks in advance. - John

 

[Guest]

You can use the format, to return only the date without the time

CDate(Format(DateField,"dd/mm/yyyy"))

 

[Marshall Barton]

I am trying to reformat a date/time field to export it without the time.
Article 291245 gives a suggestion (Method 1), but I can not figure out how to
implement the suggestion. Can not figure out how to do a new calculated
field with the suggested format.

Did you forget to create a query to use for the export?

Once you have the query open in design view, replace your
datetime field with something like:

MyDate: Format([datetimefield], "mm/dd/yyyy")

 

[Guest]

Marshall, thanks. Not exactly sure what I was doing wrong, but this did the
trick. - John

I am trying to reformat a date/time field to export it without the time.
Article 291245 gives a suggestion (Method 1), but I can not figure out how to
implement the suggestion. Can not figure out how to do a new calculated
field with the suggested format.

Did you forget to create a query to use for the export?

Once you have the query open in design view, replace your
datetime field with something like:

MyDate: Format([datetimefield], "mm/dd/yyyy")

 

[Guest]

Not sure how to mark this as the answer. Nothing comes up in the message pane.

I am trying to reformat a date/time field to export it without the time.
Article 291245 gives a suggestion (Method 1), but I can not figure out how to
implement the suggestion. Can not figure out how to do a new calculated
field with the suggested format.

Did you forget to create a query to use for the export?

Once you have the query open in design view, replace your
datetime field with something like:

MyDate: Format([datetimefield], "mm/dd/yyyy")

 

[Guest]

It's Ok, you did mark it as an answer, you can see by the green mark

Not sure how to mark this as the answer. Nothing comes up in the message pane.

I am trying to reformat a date/time field to export it without the time.
Article 291245 gives a suggestion (Method 1), but I can not figure out how to
implement the suggestion. Can not figure out how to do a new calculated
field with the suggested format.

Did you forget to create a query to use for the export?

Once you have the query open in design view, replace your
datetime field with something like:

MyDate: Format([datetimefield], "mm/dd/yyyy")

 

[Marshall Barton]

I appreciate the thought John, but don't go out of your way
marking these things. They're just used to tell other folks
with a similar question that the suggested approach worked.
There is (currently?) no personal benefit to anyone and the
vast majority of people that use a real news reader program
instead of the web interface will never see it anyway. A
simple post with "Thanks, that worked" is sufficient and
reaches a far wider audience
--
Marsh
MVP [MS Access]

Not sure how to mark this as the answer. Nothing comes up in the message pane.

I am trying to reformat a date/time field to export it without the time.
Article 291245 gives a suggestion (Method 1), but I can not figure out how to
implement the suggestion. Can not figure out how to do a new calculated
field with the suggested format.

Did you forget to create a query to use for the export?

Once you have the query open in design view, replace your
datetime field with something like:

MyDate: Format([datetimefield], "mm/dd/yyyy")