Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by tobynegus

  1. tobynegus

    SQL date formats- 01/11/09 not 11/01/09

    thanks
  2. tobynegus

    SQL date formats- 01/11/09 not 11/01/09

    thanks, I will provide a better response next time. Thank you again for your help. Any news on WHY this was happening? Toby
  3. tobynegus

    SQL date formats- 01/11/09 not 11/01/09

    DONE IT!!!!!!!!!!! thanks I altered the Insert into to get rid of the error and I now get the correct date at the other end. Thank you for your patinece I do not understand really what is going on, why it changes, from 01/11/2009 to 11/01/2009, but tthankk you Toby
  4. tobynegus

    SQL date formats- 01/11/09 not 11/01/09

    sorry! Thank you fopr your patience. I have put it into the sql, I now get a Syntax error in INSERT INTO statement, (sql below) I do not see where else it should be put, ''''' ...PricesEHT.TestedAt, #" & Format(datDate, "yyyy-mm-dd") & "#, AS datdat" ''''''''''' the result sql is ''''''''''...
  5. tobynegus

    SQL date formats- 01/11/09 not 11/01/09

    I have put it in the SQL EHT_AutolabWork.[WSL COST], PricesEHT.TestedAt, #" & datDate & "# AS datdat" But get 11/01/2009 if i put it in the GetMonthTDL function it errors as it is a string? is this problem to do with American and UK dates?
  6. tobynegus

    SQL date formats- 01/11/09 not 11/01/09

    I have tried putting '#' at each end. i.e ...[WSL COST], PricesEHT.TestedAt, #" & datDate & "# AS datdat" this returns 11/01/2009 if i take the # out I get 13/12/1899!!
  7. tobynegus

    SQL date formats- 01/11/09 not 11/01/09

    This gets the date from a table record '''''''''''''''''''''''''' Function GetMonthTDL() Dim db As Database Dim rstPathTDL As DAO.Recordset Set db = CurrentDb Dim PathTDLDate As Date On Error GoTo err_norec Set rstPathTDL = db.OpenRecordset("Pathdata_TDL", dbOpenSnapshot) 'query with records...
  8. tobynegus

    SQL date formats- 01/11/09 not 11/01/09

    Thanks, can you help a little more... There must be a simple way to do this but I can't find it. The date is being passed and inserted into the sql statement, how can I format it to #2009-11-01# without changing it into a string? Any help much appreciated Toby
  9. tobynegus

    SQL date formats- 01/11/09 not 11/01/09

    Hi PHV, sorry for the delay I have been away. Thank you for your help I am still getting an issue with the date turning up at the other database in american format month date year rather than english format date month year. The datDate used in the sql is got from a date field of a table. it...
  10. tobynegus

    SQL date formats- 01/11/09 not 11/01/09

    sorry about my dimness, i see what you are saying. the data is collected via a date field from a table, eg 19/11/2009 I am trying to get this to change to first daay of month, eg 01/11/2009, in doing sso I messup up and passed text!! I will look for a function to change the date to the First...
  11. tobynegus

    SQL date formats- 01/11/09 not 11/01/09

    Hi Thanks for the response I must be a little dumb, can you explain with more detail? I have tried the following formating datDate = Format(datDate, "yyyy-mm-dd") as Skip said, but it still comes out as 11/01/2009 (11th Jan 09)
  12. tobynegus

    Supress error on unbound control

    within your code, get it to check if there is data in the two date fields, if not get it to return null
  13. tobynegus

    SQL date formats- 01/11/09 not 11/01/09

    Tried that(Format(datDate, "d/mmm/yyyy")), but got 30/12/1899!!!!!!!!!!!
  14. tobynegus

    SQL date formats- 01/11/09 not 11/01/09

    I am runnning an INSERT SQL with IN into another database I am having trouble with date format The date the sql is getting is 01/11/09 (1st Nov 09) (this shows correct in the Immediate panel) when the data gets to the other database in comes in as 11/01/09 (11th Jan 09) how can i get this...
  15. tobynegus

    Axport Query from Access to another MDB

    sorted the SYntax get 'can't find tbl_TurnAround1 (this is the table i am trying to put data in INSERT INTO tbl_TurnAround1 ( TestCode, CodeDesc, CntCode, SellPrice, who, [where], ReqEntRsltAvgTA, ReqEntRsltMaxTA, ReqEntRsltMinTA, RsltEntAuthAvgTA, RsltEntAuthMaxTA, RsltEntAuthTA...
See more

Part and Inventory Search

Back
Top