Hello, first post on this forum so apologies for any problems/errors.
i am using Access as a database and Excel as a frontend of types to process data and create a report. i'm currently using a user entered date for the dates. however, i would like to use a date created field instead. my issue is the date created is a date/time instead of just a date which is throwing my code off. here is the code:
C4:I4 are just dates based on a userform input.
This code looks to work on some sheets, not on others (resulting in a runtime of 3464). On other sheets it works perfectly and there are very few differences (only names are different).
i have no errors if i pivot [Lead].[Date] but i do if i pivot datevalue([Lead].[Date Created]) .
date is in format "mm/dd/yyyy". date created is in format "mm/dd/yyyy hh:mm:ss". if i try to pivot without datevalue on date created, i get no data.
any suggestions on how to get around this? the access database is populated from an excel sheet. i have this as a direct import from VBA so i don't need to open the spreadsheet. i'd like to keep it like this for time/resource reasons. i've tried to search this on multiple forums but coming up empty handed.
here is a snippet of the raw data from access:
Final output:
any help on this issue is greatly appreciated!
Bookmarks