Calculating Time

[Sahubba]

Hello,

I am trying to get data from 12am to 12:59am from the pervoius week. I am able to get last week but not the time.

Can someone help me?

 

[lbass]

{table.date} in lastfullweek and
{table.time} in time(0,0,0) to time(0,59,59)

You should spend more time on your posts. You haven't even indicated what kind of fields you are working with.

-LB

 

[Sahubba]

Thank you for responding.
In the future I will add more information in my post.

I am unable to added that formula in my record selection because the date/ time feild is an formula with a shared var.

Here is the {in_time} formula
shared stringvar in_event_name;
shared stringvar in_event_dept;
shared stringvar in_event_room;
shared stringvar in_event_bed;
shared datetimevar in_event_time;

if {EVENT.TYPE_C} in [1,3] then in_event_time := {EVENT.TIME};

in_event_time

Here is my {Out_time}
Here is the {in_time} formula
shared stringvar in_event_name;
shared stringvar in_event_dept;
shared stringvar in_event_room;
shared stringvar in_event_bed;
shared datetimevar in_event_time;

if {EVENT.TYPE_C} in [2,4] then in_event_time := {EVENT.TIME};

in_event_time

I tried to put this in the formula selection

time {in_time}>= time(0,0,0)
and
time{out_time} < time(0,59,59)

but I do not see my formulas so I am unable to added them.
Thanks I hope this is enough information.

 

[lbass]

That was very significant information to leave out. But you haven't explained why you are using shared variables in the first place. Are the values for these variables coming from a subreport? Why? You can't use shared variables in selection formulas, so it is important to know why you are using them in the first place.

-LB