Date convertion issue 2/13/2004 on this newsgroup! frustrated!

I think there is a script/date interpretation issue as I cannot see all post
s for 2/13/2004
they are currently displayed as 2/12/2004 to make matters worse I posted res
ponses to 3 or 4 questions this morning and none of them show up!!! I am
very frustrated feel like spectator at the moment
I am using GMT(United Kingdom Regional setting) dd/mm/yy
I know that there are some issues relating to this on (Java/Vb script) where
if mm > 13 then U date discrepancies
can somebody confirm?/try this outplease ignore this message, appears to be fixed however the messages appeare
d 4.5 hrs after I had posted them at 08:00GMT!! all posts now appear to be d
isplaying 2/13/2004
has anybody else experienced this before'|||Use a real newsreader instead of a web-based interface <spit>.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Olu Adedeji" <anonymous@.discussions.microsoft.com> wrote in message
news:66AFE09F-0870-439C-A54A-E07DBEA49E8E@.microsoft.com...
> please ignore this message, appears to be fixed however the messages
appeared 4.5 hrs after I had posted them at 08:00GMT!! all posts now appear
to be displaying 2/13/2004
> has anybody else experienced this before'
>|||Thanks for info but running Lotus Notes (not my choice) at the office so han
ds are tied, will persevre
Thanks

Date convertion issue 2/13/2004 on this newsgroup! frustrated!

I think there is a script/date interpretation issue as I cannot see all posts for 2/13/200
they are currently displayed as 2/12/2004 to make matters worse I posted responses to 3 or 4 questions this morning and none of them show up!!! :( I am very frustrated feel like spectator at the momen
I am using GMT(United Kingdom Regional setting) dd/mm/y
I know that there are some issues relating to this on (Java/Vb script) where if mm > 13 then U date discrepancie
can somebody confirm?/try this ouplease ignore this message, appears to be fixed however the messages appeared 4.5 hrs after I had posted them at 08:00GMT!! all posts now appear to be displaying 2/13/200
has anybody else experienced this before?|||Use a real newsreader instead of a web-based interface <spit>.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Olu Adedeji" <anonymous@.discussions.microsoft.com> wrote in message
news:66AFE09F-0870-439C-A54A-E07DBEA49E8E@.microsoft.com...
> please ignore this message, appears to be fixed however the messages
appeared 4.5 hrs after I had posted them at 08:00GMT!! all posts now appear
to be displaying 2/13/2004
> has anybody else experienced this before'
>|||Thanks for info but running Lotus Notes (not my choice) at the office so hands are tied, will persevr
Thanks

Date Convertion

I am currently running a DTS package to extract data from a DB2 database.
The code reads Select * from ABC where entrydate='12/15/2005'
This works fine but I need to automate the process by selecting the date
automatically. As soon as the entrydate = formula the extract do not work.
I have tried different versions of date formula
The format of the date field on the SQL table is smalldatetime and on DB2
it is date
Can some one helpVuka
Use 'yyyymmdd' format with SQL Server
Lookup CONVERT system function in the BOL
"Vuka" <Vuka@.discussions.microsoft.com> wrote in message
news:CF33E355-6FFA-4C1F-95A8-C9EABE0CDD29@.microsoft.com...
>I am currently running a DTS package to extract data from a DB2 database.
> The code reads Select * from ABC where entrydate='12/15/2005'
> This works fine but I need to automate the process by selecting the date
> automatically. As soon as the entrydate = formula the extract do not
> work.
> I have tried different versions of date formula
> The format of the date field on the SQL table is smalldatetime and on DB2
> it is date
> Can some one help