Glenn,
I want to get the same results as kskinne. I changed both columns from 101 to 100 but the time is still showing up the same as just the date. I also would love to see the actually time that employess are punching in and out. Thanks for any help you might be able to give.
Neil
"Glenn Adams [MVP - Retail Mgmt]" wrote:
My bad - change from 101 to 100... See what happens when you work from > memory? :) >
>
>
formatting link
?frame=true>
Lookup "CAST and CONVERT" - it should describe all of the formats.. > > --
> Glenn Adams
> Tiber Creek Consulting
>
formatting link
snipped-for-privacy@tibercreek.com ----------------------------------------------> Please DO NOT respond to me directly but post all responses here in the > newsgroup so that all can share the information>
>
>
> > Glenn, the date format you are referring to in the convert function is
> > already set to 101, but it is still showing up in the report as a date > > only
> > format. any other ideas? also, where you i find out more info about the
> > convert function and other functions, as well as a list of those different
> > format codes (like 100 and 101) and what they mean?
> >
> > thanks for your help,
> > kevin
> >
> > "Glenn Adams [MVP - Retail Mgmt]" wrote:
> >
> >> There is a timecard report on the Reports Library in Customer Source.
> >> Unless MS has fixed it, it has the same problem you are describing. > >>
> >> To fix the version from Reports Library (unless it has already been fixed > >> by
> >> MS - I haven't checked in a few months):
> >> There are 2 columns with Formula defininitions. They use the CONVERT() > >> SQL
> >> function to format the date. The format selected in these convert > >> functions
> >> is a date only format - number "100". Change the "100" to "101" - note > >> that
> >> there are 2 columns, and I think each column has 2 occurrences, so make > >> sure
> >> you get them all...
> >>
> >> Hope that helps!
> >>
> >> --
> >> Glenn Adams
> >> Tiber Creek Consulting
> >>
formatting link
>> snipped-for-privacy@tibercreek.com >> ----------------------------------------------> >> Please DO NOT respond to me directly but post all responses here in the> >> newsgroup so that all can share the information> >>
> >>
> >>
> >> > i'm using activereports in RMS to generate a custome timecard report. > >> > for
> >> > my
> >> > timein and timeout colums, the datatype i have assigned to the columns > >> > is
> >> > vbDate. when I generate the report, the columns only show the date as
> >> > mm/dd/yyyy, they do not show the time of day piece for exactly when the
> >> > cashier punched in or out. is there any way to change the formatting > >> > of
> >> > this
> >> > so that in the report the time shows up? for example, instead of > >> > showing
> >> > 2/6/2005 in the time in column, it would show 2/5/2005 8:00:00 AM. > >> >
> >> > thanks in advance,
> >> > kevin
> >>
> >>
> >>
>
>
>