Jump to content

> in multiple Timestamps


This topic is 6678 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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. :blush2:

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 by Guest
Added update
Link to comment
Share on other sites

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. :wink2:

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 by Guest
Corrected typo :^)
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 6678 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.