Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

d look up

Discussion in 'Information Technology' started by Chey, Jul 28, 2006.

Tags:
  1. Chey

    Chey
    Expand Collapse
    Guest

    I need some help with this
    I have a table with 6 columns
    If my Date Ticket Purchased is between this date and this date then LC
    This is what my table looks like

    ID LC CC FY FY Start Date FY End Date
    1 06060130 6216407 06 7/1/2005 6/30/2006
    2 06070130 6216407 07 7/1/2006 6/30/2007
    3 06080130 6216407 08 7/1/2007 6/30/2008

    So if the date ticket purchased fall between any of these dates then I want
    for example the proper LC to show.
    I need to do this for LC CC and FY
    Once I get the first one I think I can do the rest.

    Thanks so much
     

Share This Page