Time Filter

Comments

5 comments

  • Avatar
    Andrew Campbell

    No, I think Joshua is looking for DD/MM/YY HH:MM format 

    1
    Comment actions Permalink
  • Avatar
    Randolph Abelardo

    You actually solved @Joshua's problem, @Carlos & @Andrew ! :) 

    To achieve the desired end result:

    1. Apply the dateFilter keyword on the relevant column.

    2. In the Awesome Table editor, enter the date and/or time format you want under the Date format in DateFilters field (under the Formatting section).


    Note
    : There's a known issue with the dateFilter. @Joshua, if this doesn't meet your specifications, please submit a Feature Request.


    - Randy

     

    0
    Comment actions Permalink
  • Avatar
    Joshua Essary

    Great! Just to be clear as to what is happening in your screenshot. Are you replacing the dates with the times, or are those time part of the date cell. I am not using a timestamp. I will be generating my own "Start Time" column for a scheduler. 

    0
    Comment actions Permalink
  • Avatar
    Randolph Abelardo

    Hi @Joshua.

    Originally, column A is from a timestamp. But it doesn't have to be in your case for the dateFilter to function and only display the time in the slider.

    But please remember that this is a hack. Since we're using a dateFilter, the underlying data-type should be in date-time format for it to work. You can enter a single arbitrary date (to retain its date structure - it won't be displayed anyway) and just use your own "start time" for your scheduler.

    For example: 1/1/2019 8:30, 1/1/2019 10:00, ...

    If this doesn't meet your specifications, we'll just wait for the update in this feature request.

    Thanks.

    - Randy

    0
    Comment actions Permalink

Please sign in to leave a comment.