Calculating Fiscal Year in SQL?


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Calculating Fiscal Year in SQL?

  1. #1
    James McFarlane Guest

    Calculating Fiscal Year in SQL?


    How do I set a fiscal year so when using the DATEPART function to get
    the week I get the fiscal week and not the calander week?

    Lets say the fiscal year starts April 1st.


  2. #2
    Mark Guest

    Re: Calculating Fiscal Year in SQL?


    I don't think there is a DATEPART function in SQL. There is one in T-SQL
    which would be specific to SQL Server. Pull up T-SQL help and the answer
    should be there.




    "James McFarlane" <jamesm@hache.com.do> wrote:
    >
    >How do I set a fiscal year so when using the DATEPART function to get
    >the week I get the fiscal week and not the calander week?
    >
    >Lets say the fiscal year starts April 1st.
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center