Sort from a date

Learn Academy Feedback
4

Hi @a.calabro, I would suggest the following steps:

  1. read range activity to load the excel-file to a datatable
  2. now it depends on the exact format of the date in the datatable. If it is already a datetime datatype, you can use filter and sort activities for your datatable.
    If the cells are in another format you should use parse or parseexact to convert it to a datetime datatype. a new column in your datatable will be usefull. I used this post to help me with converting string to date: Guidance on String/DateTime Conversion and String Manipulation - #4 by ClaytonM
  3. now you should have yout datatable as you needed.

Regards
Moritz

1 Like