Number to Date.

From: Dylan (anonymous_at_discussions.microsoft.com)
Date: 04/05/04

  • Next message: Vishal Parkar: "Re: Number to Date." 
    Date: Mon, 5 Apr 2004 07:59:37 -0700

    Hi,

    The accounts package that we use uses MSSQL for its
    database. One of the tables is for recording sales
    transactions. The due date field in this table is stored
    as INT size 4 in the YYYYMMDD format; i.e 20040405
    (today's date). I have been asked to create a script
    that will report all transactions that are x numbers past
    their due date from a specified date. So they might want
    to find out all transactions that will be 45 days overdue
    (past due date) as of the end of the month, for example.
    My problem is finding a way to convert this due_date
    filed to date format so that the date they enter can be
    deleted from it. Can anyone help?

    To recap:

    Convert 20040405 (INT) to 20040405 (YYYYMMDD - date)

    TIA,

    Dylan

  • Next message: Vishal Parkar: "Re: Number to Date."

    Relevant Pages