LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: mw9286

Hello:

How to I filter on a datetime field? I want to only pull records where the datetime is less than "2014-12-01 21:00:00"

Thank you,

Mike

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ejones

Something like this should do it:

where datetimeValue < datetime(date(2014,12,1),time(21,0,0))

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: andycooper

Originally posted by: ejones
					

Something like this should do it:


where datetimeValue < datetime(date(2014,12,1),time(21,0,0))
			

The datetime feature creates a long value so the timestamp option is the simplest way to perform the filter without having to convert the other datetime value to long as well.

Use the following example: -

where "datetimevalue" < timestamp(date(2014,11,1),time(21,0,0))

Replace "datetimevalue" with the field name you are using.

Thanks

Andy

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ejones

Thanks Andy, yes. It is better to use the timestamp() function than the datetime() function.