Forum Discussion
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
3 Replies
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
