Some date missing when extracting mails

[akika]

Hi
am extracting some range of mails based on date. however, am not getting all mails
01-Dec-24 to 15-Dec-24. I cant hardcode the date as range can vary.

for 01 dec mails after midnight to 05am are not retrieved and for15 dec after 11am are not output in file.

    startdate = Format(DateAdd("h", -myUTC, _
    CDate("01/" & Month(themonthyear) & "/" & Year(themonthyear) & " 00:00:00 AM")), "'m/d/yyyy hh:mm:ss AM/PM'")
    enddate = Format(DateAdd("h", -myUTC, _
    CDate(DateSerial(Year(themonthyear), Month(themonthyear) + 1, 0) & " 23:59:59 PM")), "'m/d/yyyy hh:mm:ss AM/PM'")

 

[Micron]

Not much there to go on. Did you step through the code and check your variable values as you go? I suggest you verify they are what you think they are.

Maybe not the cause and maybe you know this, but the Format function converts values to strings, so I imagine that whatever you do with the dates after that, you'll be passing a string to some other code or function. This is the output if I substitute Date() for themonthyear and 1 for -myUTC:
'3/1/2025 12:59:59 AM'
'1/2/2025 01:00:00 AM'

I would think you'd need date delimiters (octothorpe) for dates and not single quotes:
#3/1/2025 12:59:59 AM#
#1/2/2025 01:00:00 AM#

 

[madelineharris]

Il problema potrebbe risiedere in DateAdd("h", -myUTC, ...) se myUTC sposta l'intervallo. Controlla myUTC, usa Debug.Print startdate, enddate e controlla il formato della data in Outlook.

 

[madelineharris]

sorry, in english

The problem may be in DateAdd("h", -myUTC, ...), if myUTC shifts the range. Check myUTC, use Debug.Print startdate, enddate and check the date format in Outlook.