How to retrieve data by specified date

[yosukewatanabe]

Hi,

How can I retrieve the data by specified date?

For example, suppose I have the data as following.

2016/12/16 16:51:45,19.71875,25.96875,0.001220703
2016/12/16 16:51:55,19.84375,26,-0.027587891
2016/12/16 16:52:05,19.84375,26.0625,0.031005859
2016/12/16 16:52:15,20.34375,26.09375,0.028564453
2016/12/17 15:45:25,20.3125,26.1875,0.026611328
2016/12/17 15:46:35,20.40625,26.15625,0.05205078
2016/12/17 15:47:45,20.65625,26.125,0.00273438
2016/12/17 15:48:55,20.5,26.1875,0.063720703
2016/12/17 15:49:05,20.78125,26.21875,0.0753594

From this data,I want to get the data in 2016/12/16.

[Bob_Blackey · Accepted solution]

Hi ,

Assuming that this is coming in as one field (let's say named Field1) and you just wanted to keep those records that matched the date it would be :

A Filter tool with the filter:

Left(Field1, 10) = "2016/12/16"

If it is more detiailed than that then please post additional info.

Cheers,

Bob

[MarqueeCrew · Accepted solution]

Datetimetrim([field],"day") = [date]

Or replace [date] with "2016-12-16"

But your dates have a / instead of a -

You might just use left([field],10) == "2016/12/16"

Cheers,
Mark

[yosukewatanabe]

Hi,

By using filter tools, I could get data by specified date!

Thanks!