I am facing issue with Export to excel option from record type. we are in 19.1 and using entity backed record.
In excel the date and time is getting populated as 07/12/2019 05:16 AM CDT as text. When I double click on this and release it is getting changed to proper format.
I have formatted with text() function to remove timezone and still it is giving as text format output with value (07/12/2019 05:16 AM) and if apply filter in excel it shows as below(screen 01).
Issue is - not able to filter as date-time column. expected as in screen 02
Screen 01:
Expected is - we need to filter the date time as below -
Screen 02:
Discussion posts and replies are publicly visible