Professional Web Applications Themes

column default to fiscal year - Microsoft SQL / MS SQL Server

Hello, I would like a table column to default to the fiscal year based on current date. If datepart(month,getdate()) > 6 then FiscalYear = datepart (year,getdate()) else FiscalYear = datepart(year,getdate ()) + 1. In other words, fiscal year 2004 begins July 1, 2003. What is the best method to make this value accessible for use in tables?...

  1. #1

    Default column default to fiscal year

    Hello,

    I would like a table column to default to the fiscal year
    based on current date.

    If datepart(month,getdate()) > 6 then FiscalYear = datepart
    (year,getdate()) else FiscalYear = datepart(year,getdate
    ()) + 1.

    In other words, fiscal year 2004 begins July 1, 2003.

    What is the best method to make this value accessible for
    use in tables?
    Sue Guest

  2. #2

    Default Re: column default to fiscal year

    You define the default value like this:

    CREATE TABLE Sometable (... ,
    fiscalyear INTEGER NOT NULL
    DEFAULT
    CASE WHEN DATEPART(MONTH,CURRENT_TIMESTAMP) > 6
    THEN DATEPART(YEAR,CURRENT_TIMESTAMP)+1
    ELSE DATEPART(YEAR,CURRENT_TIMESTAMP)
    END, ... )

    Does that answer your question?

    --
    David Portas
    ------------
    Please reply only to the newsgroup
    --



    David Guest

  3. #3

    Default Re: column default to fiscal year

    Yes, to both of you. Thank you very much. I was trying to
    use IF and getdate().
     
    Sue Guest

  4. #4

    Default Re: column default to fiscal year

    GETDATE() and CURRENT_TIMESTAMP are identical in function but
    CURRENT_TIMESTAMP is standard SQL whereas GETDATE() is specific to
    SQLServer. For that reason I prefer CURRENT_TIMESTAMP.

    --
    David Portas
    ------------
    Please reply only to the newsgroup
    --

    "Sue B." <net> wrote in message
    news:02c801c34bc0$ea62bf90$gbl... [/ref]


    David Guest

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139