a week ago
I'm trying to extract the data by applying filter between 8AM to 6PM in data set. Time variable is in TIME format. Any suggestions please?
Thanks in advance
where time between '8:00't and '6:00pm't;
Where time between ‘06:00’t and ‘18:00’t;
Note the t after the time to indicate a time value.
@pappusrini wrote:Thanks. Does it matter if the time variable is the “time part” of date/time variable?I have the time variable as:8Am9AmBut this is the time part of date/time variable.Thanks