comparing times

[malonep]

Hi,

I have a start and end date time set in a cursor

and I want to see if "now" is between the start and end.

How do I compare times while ignoring the dates?

I have been using datetime but it compares dates before time.

 

[jimstarr]

SET HOURS TO 24
startx = TTOC(start, 2)
endx = TTOC(end, 2)
now = TTOC(DATETIME(), 2)
?BETWEEN(now, startx, endx)

Jim

 

[KDavie]

This may not be the best way, but I guess you could do something like this:

ldTestTime = TIME()
lcStrTran = TTOD(ldStart) && Starting Date
ldStart = STRTRAN(ldStart,lcStrTran,"")
lcStrTran = TTOD(ldEnd) && Ending Date
ldEnd = STRTRAN(ldEnd,lcStrTran,"")

IF BETWEEN(ldTestTime,ldStart,ldEnd)
	***your code here
ENDIF

Hope this helps.

-Kevin