Forum Discussion
Date Formatting
Greetings,
I have a column of dates from a system which is in a GENERAL format. The problem is, the system does not provide a day in the date; data is in mmmyy format (IE: APR19).
The p...
looks good, but I don't think 2013 has PQ. Unless you download it...unfortunately, where I work, we are not able to download add ons and upgrades until the company approves everyone upgrade to 2016.
I see, known situation. And most probably your next version will be 2019.
Bit more about two-component dates. Excel interprets them as day/month of the current year and if no success with that shifts on first day of the month/year. For example,
Apr30 will be converted to 2018-04-30, but
Apr31 to 1931-04-01
To my knowledge there is no way to change such behavior by settings, the workaround could be as Haytham suggested or similar. At the same time with regular updates and refreshing using helper column looks bit annoying, perhaps VBA script could help to update in-place with one click, but that's not my expertise.