Syntax of Datetime in condition statements

Feli — Fri, 09 Jun 2023 23:42:11 GMT

I'm quite sure there is a really simple solution for my problem but even after searching the community and the scripting index I am stuck.

I want to access all rows before a certain date in my time column, e.g. :Timestamp < "25/06/2020 12:00:00 PM"

What is the correct syntax for putting a datetime into a condition?

I've seen it in the data filter with the numeric JMP date time format, but I haven't found a function for parsing a datetime into JMP date time yet.

I guess the informat() function might help, but how do I specify JMP date time?

Re: Syntax of Datetime in condition statements

Jeff_Perkinson — Mon, 02 Nov 2020 10:27:38 GMT

Representing date, datetime and time contants in JSL requires you to specify them in a specific format. For dates, you must specify them in ddMONyyyy format, and for times, you must use dd:hh:mm:ss format. For example:

time = 14:10:15;
date = 18Jan1957;
datetime = 11Jul2000:03:10:12;

Learn more:

topic Syntax of Datetime in condition statements in Discussions

Syntax of Datetime in condition statements

Re: Syntax of Datetime in condition statements