Forum Discussion

Margaritha's avatar
Margaritha
Copper Contributor
Sep 30, 2020
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 ...
developer
office 365
  • ExcelExciting's avatar
    ExcelExciting
    Sep 30, 2020

    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

     

ExcelExciting's avatar
ExcelExciting
MVP
Sep 30, 2020

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

 

  • Margaritha's avatar
    Margaritha
    Copper Contributor
    Sep 30, 2020

    ExcelExciting 

    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!

     

    • ExcelExciting's avatar
      ExcelExciting
      MVP
      Sep 30, 2020

      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