Search results

Ok, clear explanation of what is going "wrong"

That did the trick. Perfect, thank you. Didn't know I didn't need to specify that I wanted to see the month.

Good morning all, I'm experiencing strange behavior of my month part of a date field. When I format it either format(month(date()),"mm") or format(datepart("m",date()),"mm") it both returns a month one before the actual month. January > 12 February > 01 If I don't format, it returns the...

And again a small kick, after my own holiday I came back to work and I got the remark that the same happens with weekends. If the start date of the calculation is a day in the weekend with a result in the weekend, this date is printed. However, if the start date is a Friday, it correctly skips...

Hm, that is an option, since the date is being determined by the moment a shipment has been delivered. Thanks, will investigate that workaround! ----- Workaround works ;)

Hello all, I'm working with a function created by Arnelgp to add specific holidays on freight forwarder country to a source date. Public Function fnGetHolidays(varCountryCode As Variant, dDate As Variant) As Variant Dim strSql As String Dim rs As DAO.Recordset Dim strCountryCode...

Had to make one small change: FSO.deletefolder MyPath & sResult and it works like a charm. Thanks!

Hello all, I'm trying to make a script that deletes a folder when I click a button. I'm using below code where the * translates to a weeknumber. At least, it should. If I change the * to the weeknumber (e.g. "Week 27") the folder is deleted. I think I'm using the wrong build-up with the...

Aaaargh..... :banghead: Thank you!

Good morning :) I've got a small and probably easy-to-solve Monday-morning problem, giving me an headache and a run-time error 3129 (Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.) Dim strSQLCollection As String...

Ok, that part I get, by using CDate I'm making a date value from the field. But for some reason the first part works without using CDate, and the second part doesn't. Although nothing big changes between the two parts. However, the result of my expression with using CDate is text. Either...

Hello all, I've got below expression in a query... Gross Document Performance: IIf([QRY_Gross_Performance_Document_2]![Document Upload Date] Is Null And [QRY_Gross_Performance_Document_2]![Target Date]>=Date();"Pending";IIf([QRY_Gross_Performance_Document_2]![Document Upload Date] Is Null And...

Ok, works like a charm for the export part in date format. Strange since I already tried that, probably made some mistake somewhere...

I've been looking in to your suggestion, which works indeed when I'm creating a query out of it. However, I've got a step in my database where I filter on forwarders selected in a multiselect listbox, which can only be done via VBA. If I try your suggestion in VBA I get a Compile error: Syntax...

Ok, didn't know the first part, thanks. Second, I'm always viewing in both, but do expect that the forwarders that I'm going to share the file with, view it in Excel with local regional settings. Which may vary from US to Chinese ;)

I've now build below as test code: Dim testSQL As String testSQL = "SELECT DateValue(QRY_Gross_Performance_4.[Departure Date]) as Departure INTO TBL_Test FROM QRY_Gross_Performance_4" DoCmd.RunSQL testSQL...

I'm not that well known around export specifications, but in the box "Field Information" I've got one record (as test) Field Name Departure Date The Dates, Times and Numbers is set to Date Order DMY Date Delimiter: - Time Delimiter: : Four Digit Years: checked Leading Zeros in Dates...

No, that is a Dutch language setting

Hello all, I've got a small challenge that I cannot seem to get solved. I'm exporting a query (QRY_Gross_Performance_4) to a CSV file via a SELECT SQL in VBA, since I need to apply some variable filters on it. I've got a field QRY_Gross_Performance_4.[Departure Date] that is formatted in to...

Also known as the bystander effect. The larger the group, the more people think "the others will help". Whilst everyone is thinking like that, no one acts. As volunteer in the fire brigade, I've learned to act where others step back. This way, I'm quite often, the only one to stop at for...