Forum Discussion

AFra's avatar
AFra
Helper III
5 years ago
Solved

Change date format in dataset table

Hi all,    I have a table with 200 date columns.   They are displayed in a long format. I'd like to have it displayed such as 26/10/2015 I know how to change the format column by column, b...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi,  AFra 

    Please try follow steps:

    1. Select all fields in the table in the "Model view" (select a field first,then ctrl+A to select all fields)

    2.Change the data type and format as follows:

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

Hi,  AFra 

Please try follow steps:

1. Select all fields in the table in the "Model view" (select a field first,then ctrl+A to select all fields)

2.Change the data type and format as follows:

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

AFra's avatar
AFra
Helper III
5 years ago

thanks a lot! it works nicely and it's going to save me a LOT of time : )