Hi there,
i have attached a workbook and screenshot in which i want only critical voltages and maximum timestamp of the record. and in sheet2 the count should be matched to the voltage sheet when selecting the parameters.i.e 30min, 1hour ,current day, current week and current month. and for the current week the week should start from monday or sunday of the week and for current month it should open from 1st of the month to current date. Someone please help. the below calculated field for current week and current month which i had written wrong.
if [Time Selection]='30min' then (if DATEDIFF("minute",[Interval TimeStamp],[Latest Interval TimeStamp])<=30 then [Service No] END)
elseif [Time Selection]='1hour' then (if DATEDIFF("minute",[Interval TimeStamp],[Latest Interval TimeStamp])<=59 then [Service No] end)
elseif [Time Selection]='Current day' then (if (Date([Interval TimeStamp])=today()) then [Service No] end)
elseif [Time Selection]='Current week' then (if DATEDIFF("day",[Interval TimeStamp],today()) >= 0 and DATEDIFF("day",[Interval TimeStamp],today()) <= 6 then [Service No] end)
elseif [Time Selection]='Current month' then (if DATEDIFF('month',[Interval TimeStamp],today()) >= 0 and DATEDIFF('month',[Interval TimeStamp],today()) < 12 then [Service No] end)
end
Thanks
suresh,.
