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
Hi kethaj
Can you make sure the component type that has the date in it in the record is of type "Date". Also, the column type in the table should be of date type as well.
thank you Ankita. it is working with dateTime