[AccessD] Technical test for developers

Hello Guys,

In the format, I see you using a backslash after the dd and the mm prior to
the forward slash, I have never seen this done, what is is for?

Mark


----- Original Message -----
From: "Shamil Salakhetdinov" <shamil at smsconsulting.spb.ru>
To: <accessd at databaseadvisors.com>
Sent: Wednesday, May 14, 2003 7:47 PM
Subject: Re: [AccessD] Technical test for developers


> >   Format(Date, "MM\/DD\/YYYY")
> > is the one to use. It will never fail.
> Gustav,
>
> I think that
>
> Format(Date, "YYYY\/MM\/DD")
>
> should never fail too.
>
> As for this: Format(Date, "DD\/MM\/YYYY") - as I wrote it will work
> correctly if day number is greater than 12... - of course it CANNOT be
> recommended for use...
>
> And I think that Format(Date, "YYYY\/MM\/DD") is easier to interpret for
> Europeans when they see the result of such formatting in SQL
expressions...
>
> Shamil
>
> ----- Original Message -----
> From: "Gustav Brock" <gustav at cactus.dk>
> To: <accessd at databaseadvisors.com>
> Sent: Wednesday, May 14, 2003 8:43 PM
> Subject: Re: [AccessD] Technical test for developers
>
>
> > Hi Charlotte
> >
> > > I can't help it if what I meant and what I said don't coincide.
Didn't
> > > you see the disclaimer at the bottom of my post?  Oh, yeah, that's
> > > right.  I forgot about the disclaimer.   Hmmn. <VBG>
> >
> > > What I meant was that if you format it, you need to be sure the format
> > > corresponds to a US Date format, which is mm/dd/yyyy.
> >
> > Yes, Shamil, Charlotte is right:
> >
> >   Format(Date, "MM\/DD\/YYYY")
> >
> > is the one to use. It will never fail.
> >
> > /gustav
> >
> >
> > > -----Original Message-----
> > > From: Gustav Brock [mailto:gustav at cactus.dk]
> > > Sent: Wednesday, May 14, 2003 7:54 AM
> > > To: accessd at databaseadvisors.com
> > > Subject: Re: [AccessD] Technical test for developers
> >
> >
> > > Hi Charlotte
> >
> > > Oops, Charlotte - totally confused after a hard night's sleep?
> >
> > > /gustav
> >
> >
> > >> That's assuming that the date is being inserted is in US format
> > >> already, as SQL requires.  If you format it, it may no longer be in
US
> > >> format.
> >
> > >> Charlotte Foust
> >
> > >> -----Original Message-----
> > >> From: Shamil Salakhetdinov [mailto:shamil at smsconsulting.spb.ru]
> > >> Sent: Wednesday, May 14, 2003 2:30 AM
> > >> To: accessd at databaseadvisors.com
> > >> Subject: Re: [AccessD] Technical test for developers
> >
> > >>> You might change your code in Access programming #2 to: db.Execute
> > >>> "INSERT INTO tblUpdateLog (ulDate, ulRecordCount ) VALUES ( #" &
Date
> >
> > >>> & "#, " & FlagCount & ") " which would show a lack of experience -
> > >>> and
> >
> > >>> then see if they change it to
> > >>> use:
> > >>> ---------------------------
> > >>> Dim strSQL As String
> > >>> strSQL = "INSERT INTO tblUpdateLog (ulDate, ulRecordCount ) VALUES (
> > >>> #" & Date & "#, " & FlagCount & ") " db.Execute strSQL
> >
> > >> BTW, both are incorrect - instead of Date you should have used:
> >
> > >> Format(Date, "MM\/DD\/YYYY")
> >
> > >> or
> > >> Format(Date, "YYYY\/MM\/DD")
> >
> > >> even this
> >
> > >> Format(Date, "DD\/MM\/YYYY")
> > >> should work corectly if day number is greater than 12...
> >
> > >> Or was it a kind of trap-test?
> >
> > >> Shamil
> >
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>