Post reply

Year and Quater

  • September 3, 2010 at 1:34 am

    #239818

    Parameters (Note that the fiscal year runs from 10/1->9/30)

    Completion Date Parameters.

    Month – This is the current month – Add this to the combo box as “Current Month”

    Quarter (FY – Quarter) is actually 4 combo box values.

    · FY-Q1

    · FY-Q2

    · FY-Q3

    · FT-Q4

    Fiscal Year

    I want This in Multi Select . how can i preape the data set.plz help me out.

  • September 3, 2010 at 7:05 am

    #1216135

    I don't understand your question...misspelling or something.

    Do you have a calendar table you are using, or are you trying to do this directly with date fields?

  • September 3, 2010 at 7:40 am

    #1216159

    You might want to check out the common date/time routines link in my signature.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply