This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Yes, because previously we didn't need this date as we had a different system of identifying what the date value should be for our trending that was more of a manual/vlookup process. I'm automating wherever possible at this point, so doing it that way is not an option. Whoever created the initial macro in excel, didn't change that column to a date format. Now I have ~500 fairly large files that don't have this particular date field formatted as a date. From here on out, that Excel Macro is being converted to Alteryx, and the date format problem will be fixed. However, for creating a historical database, I can't really go back in time and change the macro, and I was trying to avoid spending a few hrs opening, adjusting, and saving each file.
I'll give it a go with the 1899 date instead of the 1900 date, and since all my dates would be past 3/1/1900, I would then still need to make a 1 dat adjustment, correct?
My confusion arose when I took 1/1/1900 + the number of days from the 12/6 file -3 and got 12/6. Then I did the same equation with the 12/7 file and got 12/6 again instead of getting 12/7.
I need to put this project away for now as I've found a way to at least provide the same data I was before, though not more detailed like I was hoping. I will dive back into it next year and try again once I have some more time on my hands.