Jump to content
Sign in to follow this  
mattlight

Setting up a day from 8pm - 8pm?

Recommended Posts

I think this is the right forum for this question!?

I need to be able to search for all records within 8pm last night and 8pm today which has obvious difficulties to it since it spans over two days. And I want it to automatically via a script to print out at 8pm each evening. Also there is other problems from here on which I've posted on the Script Forum regarding automatically selecting which printer for each report whether its labels, Letter headed form or plain paper. The self acclaimed King of problems on the Forum!

How do I do a FIND of all records entered from YESTERDAY 8pm until 8pm today and then get it to SUM this information into a report that states how many sales have been processed during this time?

I hope there's enough information here to find a solution - Thanks everyone

Matt

Share this post


Link to post
Share on other sites

The easiest way is using the oAzium Date & Time Plugin..

You create a multi-keyed relationship then goto related records.

or with a find:

Fill in the date field with first yesterday's date and the time field 20:00 new request today's date and time field 20:00.

Share this post


Link to post
Share on other sites

Happy new year everyone!

How do you do an automated script? Because this would be the answer to the problem! If at 8pm I could make a number=number+1, then between the hours of 8pm and 7:59pm the next evening, every transaction or new record would have a number that is in common which I could use to search with.

I still do not understand how to make it automated without the use of some plug-in - I know it should be possible to get it to do it.

Please help

Thanks guys n guls

Share this post


Link to post
Share on other sites

Create a field that is the concatination of the date and time.

Each record will have the following: 01032002 1935 (or some variation)

Then create a global text field that will contain every Combination between

Yesterday at 8pm to Today at 8pm. seperated by returns

01022002 2000

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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