LastFullMonth ignoring time portion

[ginkoba]

I'm trying to pull data using LastFullMonth. Problem is my count not accurate as this function ignores the time portion. Is there a way to include the time portion with LastFullMonth?

my record selection is :
{@end_date} IN minimum(lastfullmonth) to maximum(lastfullmonth)

 

[lbass]

Lastfullmonth should honor the time portion, i.e., it should include records up to 23:59:59 of the last date of the month, so I think we need to see the content of your enddate formula.

-LB

 

[ginkoba]

This is the content of my {@end_date}. It is converting a java date to a date time and applying a UTC to EST/EDT convertion as well.

ShiftDateTime(DateAdd("s",{ENDINGDATE/1000,Date(1970,1,1)),"UTC,0", "")

Now when I redo the report using date/time parameters, I get less in count than when I use LastFullMonth. I get a count of 646 when I filter using the date/time parameters and I get 695 when I use LastFullMonth.

 

[lbass]

If you get a lower number with the datetime parameters, then you are writing that formula incorrectly. So please show what that formula looks like. Or you are entering the parameter selections incorrectly. If you are using datetime parameters, then the ending parameter should end with: 23,59,59.

-LB

 

[ginkoba]

I will double check the time portion as you suggested and get back with you. I also came across a CR document and a also this link from this forum that talked about LastFullMonth ignoring the time portion or beginning at 00:00:00. See thread below:

http://www.tek-tips.com/viewthread.cfm?qid=1085214&page=9

 

[lbass]

If you write a formula:

maximum(lastfullmonth)

...it will return 2/28/2010 00:00:00. However, if you then write a formula:

{table.datetime} <= maximum(lastfullmonth)

...it will be true for datetimes like:

2/28/2010 07:59:15

So it is only evaluating the date part of the datetime, which means that any time on the last day of the month will be included.

-LB

 

[ginkoba]

Very important point you raise lbass. I will do further testing and let you know.