filter on date

[#1]

Hi

As part of the load process is it possible to easily restrict the dates the data loads for?  So for example, if i only want it to load a year, or a month at a time?

Thanks

[Colin-Albert]

Unless you are dealing with massive data sets it is better to load all data and let your users filter the data using list boxes for Year & Month.

You can add a sheet trigger to set an initial selection or use bookmarks.

[MK_QSL]

Load * From TableName

Where Date >= Date('01/01/2014','DD/MM/YYYY') ;

or

Load * From TableName

Where Year >= 2014;

[#4]

yeah thats what I have done is to load everything and then use the year,quarter and month dims for filter criteria.

In my load script I have set it such that it loads >2012 based on client requirements.

I am dealing with alot of data.

[maleksafa]

you can do that from the script when loading the data by setting a condition on the year like year >= 2012 or do it dynamically year >= addyear(today(),-2)

[MK_QSL]

There could be a possibility of Date formatting.

Let me know what exactly you want to load.

If possible, prepare a 10-15 lines dummy data in excel file and provide what output you required.