Sep 30 2020 01:42 AM
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?
Sep 30 2020 03:25 AM - edited Sep 30 2020 03:26 AM
SolutionHi @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
Sep 30 2020 05:51 AM
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!
Sep 30 2020 06:07 AM
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
Sep 30 2020 03:25 AM - edited Sep 30 2020 03:26 AM
SolutionHi @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