How can I select from the table only the last day of the month?

[#1]

Hi

How can I select from the table only the last day of the month?

In this table I want do show stock on the last day of the month.

[sunny_talwar]

How can you select? Not sure what you mean, can you elaborate and may be share a sample with expected output

[#3]

In the database i have the data you can see below. For this i want to filter only the day ending the month.

2015-01-04
2015-01-11
2015-01-18
2015-01-25
2015-01-31
2015-02-01
2015-02-08
2015-02-15
2015-02-22
2015-02-28
2015-03-01
2015-03-08
2015-03-15
2015-03-22
2015-03-29
2015-03-31

[Anonymous]

Hi

try this  for the last day in a month .

Day(MonthEnd(STA_Datastanu))

[Anonymous]

This is the date of the last day of month.

Date(Floor(MonthEnd(YourDateField)))

Regards!

[Mark_Little]

Hi,

There are a few options.

As the people have mentioned above.

I would normally flag dates like this in my calendar.

So Add if(Date = Monthend(Date),1,0) As MonthEnd,

Then  the Set analysis would be SUM({<MonthEnd={1}>}Stock)

For example.

Mark