Forum Discussion
Solved
date
Who can help me.
I would like to change a date format.
In my word (and outlook) document I enter a date (by inserting date and time and a chosen format). For example: 2020-09-30. I have chosen for the date to be updated automatically.
Now I want to change the format to 20200930 (so without dashes). If I click on Alt F9 and remove the dashes and then click on Alt F9 again nothing has changed.
What am I doing wrong?
Hi Margaritha
if I'm not mistaking you are referring to this. pls share the screenshot
If this is what you need you have select that field > right-click > Edit Field >change the format "Field properties > Date Formats". This will be easy for changing the format.
Alt+F9 the field value should look like this
{ DATE \@ "YYYYMMDD" }Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer and like to help the other members find it more
Hi Margaritha
if I'm not mistaking you are referring to this. pls share the screenshot
If this is what you need you have select that field > right-click > Edit Field >change the format "Field properties > Date Formats". This will be easy for changing the format.
Alt+F9 the field value should look like this
{ DATE \@ "YYYYMMDD" }Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer and like to help the other members find it more
Thank you very much. I see what's wrong. When i look with F9 this appears:
{ TIME /@"yyyy-MM-dd" }
if i remove the dashes in this code nothing happens. But if I change TIME to DATE the program asks to update .... and then it is ok!
Hi Margaritha
Glad to hear your query is resolved 😃 & thanks for sharing your experience
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer and like to help the other members find it more
