display date w/o time

[Guest]

I posted this question last week, but still need help. I want my report to
display the date without displaying the time. This is a date field that is
stored in my table

In the design of my report, I have done the following:
For that text box, the control source : [file date]
the format : short date

I've even tried the control source : [file date]
the format : MM/DD/YYYY

I've defined the field in my table with a format of short date, and the time
does not display when I query the table. I display the date on a form, then
the report pulls the date off the screen. So, what could be over riding the
format ???


Thanks again,
Nancy

 

[Guest]

Format is how the data is displayed. It is not the data itself. If you want
the date to show up a certain way in a report, that's where you need to apply
the formatting.

 

[Guest]

I must be missing something ... I did specify in the design of the report
that the format = short date - which did not work. Then I tried format =
mm/dd/yyyy, again in the design of the report - and that did not work either
.. So something must be over riding my format !

Format is how the data is displayed. It is not the data itself. If you want
the date to show up a certain way in a report, that's where you need to apply
the formatting.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

I posted this question last week, but still need help. I want my report to
display the date without displaying the time. This is a date field that is
stored in my table

In the design of my report, I have done the following:
For that text box, the control source : [file date]
the format : short date

I've even tried the control source : [file date]
the format : MM/DD/YYYY

I've defined the field in my table with a format of short date, and the time
does not display when I query the table. I display the date on a form, then
the report pulls the date off the screen. So, what could be over riding the
format ???


Thanks again,
Nancy

 

[Bob Barrows [MVP]]

The Table-Design Format property only controls how dates are displayed and
entered. It does not control how they are stored.

No matter what format was used to enter them, Date/Times are always stored
as Doubles, with the whole number portion representing the number of days
since the seed date, and the decimal portion representing the time of
day ).0 = midnight, .5 = noon)

Having said that, I'm surprised your report is ignoring the Format property.
In fact, when using Date/Time fields in a report I just created, I cannot
reproduce your symptoms. The newly created report obeyed the Formats
property values I used when designing the table. Also, it properly responds
to changes I make in the Format properties of the controls used to display
the date/time values.

Specifying "mm/dd/yyyy" SHOULD have worked for you ("Short Date" might
produce unexpected results if the Regional Settings on your computer specify
a different format for Short Dates ... )

I tried to reproduce your symptoms using both A97 and AXP.

Sorry I could not be of help.

Bob Barrows

I must be missing something ... I did specify in the design of the
report
that the format = short date - which did not work. Then I tried
format = mm/dd/yyyy, again in the design of the report - and that did
not work either . So something must be over riding my format !

Format is how the data is displayed. It is not the data itself. If
you want the date to show up a certain way in a report, that's where
you need to apply the formatting.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

I posted this question last week, but still need help. I want my
report to display the date without displaying the time. This is a
date field that is stored in my table

In the design of my report, I have done the following:
For that text box, the control source : [file date]
the format : short date

I've even tried the control source : [file date]
the format : MM/DD/YYYY

I've defined the field in my table with a format of short date, and
the time does not display when I query the table. I display the
date on a form, then the report pulls the date off the screen.
So, what could be over riding the format ???


Thanks again,
Nancy

 

[Guest]

O.K. thanks for the explanation Bob. Must be I'm just dealing with a quirk

The Table-Design Format property only controls how dates are displayed and
entered. It does not control how they are stored.

No matter what format was used to enter them, Date/Times are always stored
as Doubles, with the whole number portion representing the number of days
since the seed date, and the decimal portion representing the time of
day ).0 = midnight, .5 = noon)

Having said that, I'm surprised your report is ignoring the Format property.
In fact, when using Date/Time fields in a report I just created, I cannot
reproduce your symptoms. The newly created report obeyed the Formats
property values I used when designing the table. Also, it properly responds
to changes I make in the Format properties of the controls used to display
the date/time values.

Specifying "mm/dd/yyyy" SHOULD have worked for you ("Short Date" might
produce unexpected results if the Regional Settings on your computer specify
a different format for Short Dates ... )

I tried to reproduce your symptoms using both A97 and AXP.

Sorry I could not be of help.

Bob Barrows

I must be missing something ... I did specify in the design of the
report
that the format = short date - which did not work. Then I tried
format = mm/dd/yyyy, again in the design of the report - and that did
not work either . So something must be over riding my format !

Format is how the data is displayed. It is not the data itself. If
you want the date to show up a certain way in a report, that's where
you need to apply the formatting.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


:

I posted this question last week, but still need help. I want my
report to display the date without displaying the time. This is a
date field that is stored in my table

In the design of my report, I have done the following:
For that text box, the control source : [file date]
the format : short date

I've even tried the control source : [file date]
the format : MM/DD/YYYY

I've defined the field in my table with a format of short date, and
the time does not display when I query the table. I display the
date on a form, then the report pulls the date off the screen.
So, what could be over riding the format ???


Thanks again,
Nancy

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"