> in multiple Timestamps

[LaRetta]

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, 2005 by Guest
Added update

[SurferNate]

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

[LaRetta]

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, 2005 by Guest
Corrected typo :^)

[SurferNate]

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.

[LaRetta]

Hi Nathan,

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