226054_en-US

liliconcom

Filter by datetime values (in/format issue, scripting)

Hi community

Maybe you can help with this one: I'd like to do a simple  SELECT WHERE on a DATETIMESTAMP field 

2019.02.01 00:00:02

2019.02.01 11:31:04

2019.02.02 00:00:04 etc.

 

I would just like to keep datetime values between 00:10:00 and 08:00:00 on the 2019.02.01.

To accomplish this I wrote something using INFORMAT like

SELECT WHERE :DATETIMESTAMP >= informat("2019Feb01 00:10:00", "MDYHMS") & 

                              :DATETIMESTAMP <= informat("2019Feb01 08:10:00", "MDYHMS");

 

Unfortunately, it doen't work.

Can you see my mistake?

 

Thanks a lot in advance

Newbie

Re: Filter by datetime values (in/format issue, scripting)

Your Informat function specification is incorrect.  The format you specify is not a valid JMP format.  Try reseting your informat statements to this structure

informat("01Feb2019 00:10:00", "ddmonyyyy h:m:s")

Re: Filter by datetime values (in/format issue, scripting)You saved my day
Thanks a lot!