I want all records which have a creation or modification timestamp greater than 12/12/2005 11:59 PM. I want a 1 boolean. I've tried (calculation number):

CreateTimeStamp > Timestamp(12/12/2005; 11:59:00 ) or

ModifTimeStamp > Timestamp(12/12/2005; 11:59:00 ) ... it says ':59:00' field can't be found

CreateTimeStamp > Timestamp(12/12/2005; 11 PM) or

ModifTimeStamp > Timestamp(12/12/2005; 11 PM) ... it says the PM field can't be found

CreateTimeStamp > 12/12/2005 11:59:00 or

ModifTimeStamp > 12/12/2005 11:59:00 ... everything from first :59:00 on is highlighted needing operator. Geez.

I've tried many other things but I"ll spare you. Do I need to compute the total seconds of 12/12/2005 11:59PM and then wrap seconds around my fields for comparison? Surely this shouldn't be difficult but I can't see it.

Correction to above: [color:red]Actually, it's 10:52 PM on 12/12/2005. In case I was given math, I thought you should have the real figures.

LaRetta

Edited December 15, 200520 yr by Guest
Added update

Case(CreateTimeStamp > Timestamp(Date(12;12;2005);Time(20;52;59)) ;1 ; 0 )

This works. I just tried it.

P.S. - It's nice to know that the experts have these moments too!

;-)

Nathan

Hi Nathan!

"P.S. - It's nice to know that the experts have these moments too!"

I'm not but I do ... not an expert and I have WAY TOO MANY such moments. :qwery:

It worked perfectly, thanks so much.

I ended up using:

CreateTimeStamp > Timestamp(Date(12;12;2005); Time(22;52;0 )) or

ModifTimeStamp > Timestamp(Date(12;12;2005); Time(22;52;0 ))

Having a single search field, when needing to quickly identify all modified and new records (such as for an emergency export/migration) is quite handy. I think I'll make a custom function and include a global date/time (or timestamp) field for comparison. Then I can just plug in my global values whenever I need to retrieve data in a hurry; which can be accessed easily from all my tables.

Other ideas welcome as well ...

LaRetta

Edited December 15, 200520 yr by Guest
Corrected typo :^)

I'm fairly certain that Date() and Time() can reference Date and Time fields for their respective values. I do think it would need two separate reference fields though. Does a Timestamp field automatically force the full format? Would that be an irritant to a user? From the user standpoint it's usually better to give them PHD (Push Here Dummy) forms that require almost no thinking about correct data formatting.

Hi Nathan,

Nope, this isn't for Users. This is only for Developer scripted find for recovery process work. Thanks!