how to get current month records

[paulwalker]

how to get current month records

[#2]

Hi,

Use Month(Today()), this gives you the current month.

[rrsrini2907]

Hi Paul,

Assuming Current month is the latest month for which the data is present.

If you want to get current month record at script level,

1. find the max of Date and convert the date to month
2. apply the filter on date by converting the date to month is equal to Month of max of Date.
3. Execute the script.
4. The data is loaded with the Latest data.

[MayilVahanan]

HI

You want to check both Year and Month to get the current Month data.

For ex:

Load * from tablename where Year = Year(Today()) and Month = Month(Today())

or

Load * from tablename where Date >= Date(MonthStart(Today()),'DD/MM/YYYY');

Note:

Date format based on your date field

[brijesh1991]

Hi,

You must have row updation date in your table; e.g we are considering it as LastUpdatedDate.

At Script Level:

TabMain:

Load ID, Amount, LastUpdatedDate, Month(LastUpdatedDate) as Month, year(LastUpdatedDate) as Year From Table;

Tab:

Load * resident TabMain where Month=Month(Today) and Year=Year(Today());

drop table TabMain;

------------------------------------------

At Expression Level:

Sum({$<Month={'$(=Month(Today()))'}, Year={'$(=Year(Today()))'}>}Amount)

[MK_QSL]

What type of records you want to get?

It is like total sale for this month or like Total Sale for each customer?

Please specify for more visibility.

[paulwalker]

Hi Manish,

It is like total sale for this month