[AccessD] Technical test for developers

this causes the next character (/) to be a text character
Lembit Soobik

----- Original Message ----- 
From: "Mark L. Breen" <subs at solution-providers.ie>
To: <accessd at databaseadvisors.com>
Sent: Friday, May 16, 2003 12:29 PM
Subject: Re: [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
> >
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>