topic Problem using DATETIME in IF statement in Libraries & objects

Problem using DATETIME in IF statement

jakubc7 — Fri, 18 Jul 2014 05:00:08 GMT

I'm trying to write a code that will PRINT a message if it's a certain time or day.
I managed to REQUEST the time and day ... call it out using TEXT2, however I cannot use it in IF THEN ENDIF statement.

The code doesn't come up with errors until I try to save (error in 2d script ... even though 2d is empty). I'm sure I'm missing something minor.

Any help appreciated. Thanks.

MASTER CODE
!---Time and Day Limits---
hour=0
day=0

a = REQUEST("DateTime","%H",hour)
b = REQUEST("DateTime","%w",day)

IF day = 13 THEN
PRINT "It's lunch time."
ENDIF

Re: Problem using DATETIME in IF statement

Barry Kelly — Fri, 18 Jul 2014 06:05:06 GMT

The returned hour and day variables are actually text variables (even though you initialised them as numbers).
You will need to convert them to numbers.
Try...

n=SPLIT(hour ,"%n",hour_num)

n=SPLIT(day ,"%n",day_num)

To prove it if you were to type ... PRINT hour + hour
you would get 1313 (if it was 1.00pm)

but ... PRINT hour_num + hour_num
you will get 26

Barry.

Re: Problem using DATETIME in IF statement

jakubc7 — Fri, 18 Jul 2014 07:00:48 GMT

Thanks again Barry.
I was reading that the date and time are not actual numbers but couldn't find a way to convert it.

Thank you!