Forum Discussion
Timestamp Column
How can I pull out data from below column that will show requests before thursday @ 3:30pm and after ending on Sunday. Hope I explained that right? Timestamp 2018-10-10 12:40:27 2...
Hi Anonymous
You could create a new table:
NewTable = FILTER ( Table1; Table1[Timestamp] >= DATE ( Year1; Month1; Day1 ) + TIME ( Hour1; Month1; Second1 ) &&
Table1[Timestamp] <= DATE ( Year2; Month2; Day2 ) + TIME ( Hour2; Month2; Second2 ) )where Table1 is your current table and Year1, Month1, etc and Year2, Month2, etc. are the initial and final date/time within which you want to keep dates (your Thursday and Sunday in your example),
AlB
Community Champion
Community ChampionHi Anonymous
You could create a new table:
NewTable =
FILTER (
Table1;
Table1[Timestamp] >= DATE ( Year1; Month1; Day1 ) + TIME ( Hour1; Month1; Second1 )
&&
Table1[Timestamp] <= DATE ( Year2; Month2; Day2 ) + TIME ( Hour2; Month2; Second2 )
)where Table1 is your current table and Year1, Month1, etc and Year2, Month2, etc. are the initial and final date/time within which you want to keep dates (your Thursday and Sunday in your example),
Syntax error was for new table.