Ask Experts Questions for FREE Help !
Ask
    MUHAIMEN's Avatar
    MUHAIMEN Posts: 44, Reputation: 1
    Junior Member
    		  
    #1

    Jul 21, 2008, 03:52 AM
    Date are not reading complete
    Hi, I would like to ask a question regarding my program, when I make report in the end of the month my program doesn't give me all the date I want. For instance, suppose I have to print from between #01-02-08# and #31-02-08# all the data in the #31-02-08# has not giving all the data inside that day. What I noticed is, every time I give the date the last date is not giving the complete data. I hope you understand my question. Thanks in advance for the help.:confused:
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #2

    Jul 21, 2008, 05:36 AM
    Well if you are enterring those dates, that will cause a problem since 31-02-08 is an invalid data value. There are only 29 days in February of 2008. Try setting your criteria to:

    BETWEEN #01-02-08# AND #29.02.08#
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #3

    Jul 22, 2008, 05:44 AM
    First, may I call your attention to the guidelines for using the comments feature found here:

    https://www.askmehelpdesk.com/feedba...ure-24951.html

    If a suggestion didn't work, then ask for follow-up before giving a negative rating. I answered what was the most obvious problem. If that didn't work, then you ask for follow-up.

    Another issue is your regional settings. You may have to enter the values in US date format, i.e. mm/dd/yy. But I can assure that BETWEEN startdate AND enddate works.
    MUHAIMEN's Avatar
    MUHAIMEN Posts: 44, Reputation: 1
    Junior Member
    		  
    #4

    Aug 6, 2008, 12:15 PM
    I am aking apologize for this mistake comment.
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #5

    Aug 6, 2008, 12:17 PM
    No problem
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Reading a Tire's Manufacturing Date [ 0 Answers ]

Studies show that tires more than 6 years old can be very dangerous. Ensure that your "new" tires were recently manufactured, not sitting in the warehouse for years. Here's how to read the code on tires; for example, (3307) means the tire was manufactured in the 33rd week of 2007. The tire's...

How do I complete this? [ 8 Answers ]

A pellet gun is fired straight downward from the edge of a cliff that is 15.9 m above the ground. The pellet strikes the ground with a speed of 34.3 m/s. How far above the cliff would the pellet have gone had the gun been fired straight upward?

Complete the Sequence [ 1 Answers ]

The number which best completes the sequence below is: 2 6 3 8 6 12 ?

To-date total based on current date [ 1 Answers ]

:confused: I am trying to create a forumula that will give a cumulative or "to-date" total that will exclude future months from the total. i.e. ithe point in time is August and I need to show a to-date number Through August only even though September and October are included in The...

F-1 to H-1, what's the start date of H-1? Should be approval date or visa issue day? [ 3 Answers ]

As I mention before, I changed from F-1 to H-1 last year. I got my H-1 status in Feb 2004, but I went to my home country to get the H-1 visa stamp in August 2004. So I would like to know for counting my H-1 status, is it the date that USCIS (the Immigration) approved (which is Feb 1st), or the...

View more questions Search