• Can u give some more information? Perhaps add some samples to clarify your question?

    I assume you have a table with a column with datatype BIGINT. You use that column to store date-values, like the sample below.

    ID...BigINT_Date

    1.....20131210

    2.....20131211

    3.....20131212

    4.....20131213

    To filter the data is specific to the notation used to store the date value. If it is stored in yyyymmdd format (like my sample) you could just filter using the < and > comparison. If it is stored in a mmddyyyy format it will be more complicated. You first need to convert the value to a datetime datatype and then use the < and > comparison.

    But my assumption about your situation could be completely wrong, so please give us more information!!

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **