Display month range hh:mm:ss on report?

[timbaktuu]

hello everyone,
I did this on report and it showed only 1/1/2011 - 1/31/2011

CStr(Minimum(LastFullMonth)) + "-"+ CStr(Maximum(LastFullMonth))

I want to show on report 1/1/2011 00:00:00 - 1/31/2011 00:00:00, how do i do that? i tried totext did not work.

also I am running my rpt as (last full month) is there a way to select 8 to9 data for this monthly rpt.

Thanks for your help.

 

[IanWaterman]

CStr(Minimum(LastFullMonth)) + " 00:00:00 "+"-"+ CStr(Maximum(LastFullMonth)) + " 00:00:00"

Ian

 

[briangriffin]

Check out help on the totext function - there are links to the various format strings for dates and times.


totext(datetime(Minimum(LastFullMonth)),"M/d/yyyy HH:mm:ss") + " - " + totext(datetime(Maximum(LastFullMonth)),"M/d/yyyy HH:mm:ss")


I'm not sure what you're asking about the 8 to 9 data.

 

[timbaktuu]

thanks Ian and Brian,



About 8 -9 data means. when its run on first of every month then it should show last month's each business day where data should be between 8 am to 9 am (table.timestamp).hope I am clear.

Also I was making one weekly report and need to display last 5 working days. when I try min max with (last full week) , it shows sat and sun included, which I dont want.? what am I doing wrong? I just want to show 1/24/11 to 1/28/11 instead of 1/23/11 to 1/29/11

thanks

 

[briangriffin]

You only want records between 8 and 9 am?

time(yourdatetimefield) >= time("08:00:00")
and
time(yourdatetimefield) <= time("09:00:00")


As for excluding weekends, try adding to your current selection formula:

dayofweek(yourdatetimefield) not in [1,7]

Not sure I'm reading your intent properly, but hopefully this will get you going in the right direction.

 

[timbaktuu]

Thank you Brian.