Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-10-2022, 04:14 PM
A.Mac A.Mac is offline Visio Shape Data - Date formatting is getting confused Windows 10 Visio Shape Data - Date formatting is getting confused Office 2021
Novice
Visio Shape Data - Date formatting is getting confused
 
Join Date: Nov 2022
Posts: 1
A.Mac is on a distinguished road
Default Visio Shape Data - Date formatting is getting confused

I'm trying to use shape data to add a formatted date to a title block. The shape data is defined as date type with the format set to {{dd MMM yyyy}}. When I click on the box it brings up a calendar for me to select the date. Depending on what date I select, it may or may not display the date correctly.

It seems to be an issue where if the day of the month that is selected is 12 or less, then Visio decides that the day is actually the month.

For example, if I select 12 Nov 2022 then it gets displayed as 11 Dec 2022, but if I select 13 Nov 2022 then it displays as 13 Nov 2022.

Does anyone know how to fix this? I'm using Visio version 2210.

Thanks,
Reply With Quote
  #2  
Old 11-11-2022, 06:42 PM
Guessed's Avatar
Guessed Guessed is offline Visio Shape Data - Date formatting is getting confused Windows 10 Visio Shape Data - Date formatting is getting confused Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

I can confirm this issue on my version of Visio too. I don't have a solution for the problem but I googled and found an article talking about it here Visio Date Format Pictures Affect Data Entry via the Calendar Popup - bVisual

I had a play with the Windows Regional settings and note that if I change Windows to use a US regional format then the date picker in Visio gives a correct answer. Of course this is a dud solution for the majority of the world's population so hopefully someone else can find a way to solve this.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count shape in a mock-up in MS Visio benjamin213 Visio 2 06-09-2022 04:47 AM
Visio 2016 New homemade Shape Data export with Network Shape Data Karlderxte Visio 1 08-17-2021 04:04 PM
MS Visio 2013 vertically centre data in a shape after deleting all other data Belachenko123 Visio 1 11-24-2015 09:42 AM
Visio Shape Data - Date formatting is getting confused conditional formatting - I am confused parachamk Excel 1 07-03-2014 09:54 AM
VISIO - Formatting Shape Data Details TABLE Lora Visio 0 07-19-2010 12:15 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:02 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft