MaleXLR Posted May 26, 2012 Share Posted May 26, 2012 We are using an adapted VAA titleblock and on most (but not all) of our Windows computers, the revision dates (including revision dates carried through to worksheets) will only display as mmddyy, despite all our efforts with regional settings, cell format, etc. Apparently this is a bug which will be fixed in the next release, but does anyone have a workaround for the non-U.S.A., format minority??? Quote Link to comment
michaelk Posted May 27, 2012 Share Posted May 27, 2012 In the US version worksheets will display 13 date/time formats: mm/dd/yy mm/dd/yy hh:mm dd/mm/yy dd/mm/y hh:mm yy/mm/dd yy/mm/dd hh:mm dd-Month-yy dd-Month Month-yy hh:mm hh:mm:ss hh:mm PM(AM) hh:mm:ss PM(AM) Example attached. hth mk Quote Link to comment
MaleXLR Posted May 27, 2012 Author Share Posted May 27, 2012 Thanks for the response... Yes, we have the same cell format options here, but changing the cell format strangely doesn't change the date that originated from the revision of a VAA Titleblock. I just discovered that my computer at home generates ddmmyy, whereas my work computer generates mmddyy. This explains why on a recent job, revisions done at home appear on the worksheet in one format and on the same file, revisions done at the office appear in a different format! Quote Link to comment
bonus Posted May 28, 2012 Share Posted May 28, 2012 A far more comprehensive format yyyy/mm/dd would be something to wish for. Quote Link to comment
Christiaan Posted May 28, 2012 Share Posted May 28, 2012 No we're not in a minority but it can often seem that way in NZ. Quote Link to comment
Chris D Posted May 28, 2012 Share Posted May 28, 2012 YYYY-MM-DD is the ISO standard and should be the default for everything in VW. It's like ignoring international conventions like IFC to use a parochial format such as the US date format, which is very much the minority date format in the world. The US is practically the only country to put the month first. Quote Link to comment
MaleXLR Posted July 3, 2016 Author Share Posted July 3, 2016 I know, I know... and old post, but the problem has reared it's ugly head again. It was fixed sometime back, but now with VW 2016 and Windows 10 it has returned again to bloody haunt me. Is there a register of how many things get fixed and then get "unfixed"??? Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.