The date in SQL shows up
as 729089
Even in Excel the grid shows for eg. the data as 3/29/3896 when I format
the date as a Date.

I was provided the following information but I am not sure how to change the
date to show correctly.

-------------------

Platinum SQL Version 4.2

Date solution:


'The next two constants are the same date in SQL and Platinum formats.

Global Const gstrPLAT_EQUATE_DATE = "'1/1/98'"

Global Const glngPLAT_EQUATE_DATE = 729390

'The SQL expression
DATEDIFF(dd,gstrPLAT_EQUATE_DATE,sqldate)+glngPLAT _EQUATE_DATE

' converts a SQL date to the equivalent Platinum date.

'The SQL expression
DATEADD(dd,platdate-glngPLAT_EQUATE_DATE,gstrPLAT_EQUATE_DATE)

' converts a Platinum date to the equivalent SQL date





Thank you very much for your assistnace.


S Commar

s_commar (AT) hotmail (DOT) com

Ok So it looks as though platinum has an offset date. This is hours past
1/1/1900 00:00:00.

DateAdd() will allow you to translate this to a date.

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Sam" <s_commar (AT) hotmail (DOT) com> wrote

Thanks for your assistance.

So can I do an update statement. Could you please advise as I am not
sure what I have to do exactly to sort this out.

Thank you for your assistance.

S Commar



*** Sent via Developersdex http://www.developersdex.com ***

You can do an UPDATE but this will be different. You can either

1. Use a Data Driven Query Task
2. Use a Linked Server
3. Transfer the rows locally and do the update.



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Sandeep Commar" <s_commar (AT) hotmail (DOT) com> wrote