Recent content by Scaniafan

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 ;)