SOLVED

date

%3CLINGO-SUB%20id%3D%22lingo-sub-1728032%22%20slang%3D%22en-US%22%3Edate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1728032%22%20slang%3D%22en-US%22%3E%3CP%3EWho%20can%20help%20me.%3CBR%20%2F%3EI%20would%20like%20to%20change%20a%20date%20format.%3CBR%20%2F%3EIn%20my%20word%20(and%20outlook)%20document%20I%20enter%20a%20date%20(by%20inserting%20date%20and%20time%20and%20a%20chosen%20format).%20For%20example%3A%202020-09-30.%20I%20have%20chosen%20for%20the%20date%20to%20be%20updated%20automatically.%3C%2FP%3E%3CP%3ENow%20I%20want%20to%20change%20the%20format%20to%2020200930%20(so%20without%20dashes).%20If%20I%20click%20on%20Alt%20F9%20and%20remove%20the%20dashes%20and%20then%20click%20on%20Alt%20F9%20again%20nothing%20has%20changed.%3CBR%20%2F%3EWhat%20am%20I%20doing%20wrong%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1728032%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1728410%22%20slang%3D%22en-US%22%3ERe%3A%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1728410%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F814541%22%20target%3D%22_blank%22%3E%40Margaritha%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20I'm%20not%20mistaking%20you%20are%20referring%20to%20this.%20pls%20share%20the%20screenshot%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20this%20is%20what%20you%20need%20you%20have%20select%20that%20field%20%26gt%3B%20right-click%20%26gt%3B%20Edit%20Field%20%26gt%3Bchange%20the%20format%20%22Field%20properties%20%26gt%3B%20Date%20Formats%22.%20This%20will%20be%20easy%20for%20changing%20the%20format.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Snag_2c4b61d6.png%22%20style%3D%22width%3A%20641px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F223026i359F04041C264A76%2Fimage-dimensions%2F641x348%3Fv%3D1.0%22%20width%3D%22641%22%20height%3D%22348%22%20title%3D%22Snag_2c4b61d6.png%22%20alt%3D%22Snag_2c4b61d6.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlt%2BF9%20the%20field%20value%20should%20look%20like%20this%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%7B%20DATE%20%5C%40%20%22YYYYMMDD%22%20%7D%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%2FBest%20Answer%20and%20like%20to%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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?

3 Replies
Highlighted
Best Response confirmed by Margaritha (New Contributor)
Solution

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.

 

Snag_2c4b61d6.png

 

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

 

Highlighted

@Faraz Shaikh 

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!

 

Highlighted

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