Syntax of Datetime in condition statements

[#1]

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?

[#2 · Accepted solution]

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: Using dates, times, datetimes and durations in JMP