Forum Discussion

waydec's avatar
waydec
Frequent Visitor
4 years ago
Solved

Date and time filtering

Hi,   I'm looking for a way to show information for a user selectable period using a single datetime field.  This datetime field shows the date and time that a job was created in our job management...
Need Help
  • waydec's avatar
    waydec
    4 years ago

    Hi Ibendlin,

     

    Perhaps I was not clear on what I'm looking for but for now I've solved my own issue by copying the datetime column to a new column in the same table, changing the datatype of the new column to a decimal with 4 decimal places and using the decimal number in the new column to filter out the data for the datetime from and to periods I need.  I will build a converter table that looks up the actual date and time the date time serial number represents to make it easier for the users.

     

    Thanks for your help.

    Waydec

     

waydec's avatar
waydec
Frequent Visitor
4 years ago

Hi Ibendlin,

 

Perhaps I was not clear on what I'm looking for but for now I've solved my own issue by copying the datetime column to a new column in the same table, changing the datatype of the new column to a decimal with 4 decimal places and using the decimal number in the new column to filter out the data for the datetime from and to periods I need.  I will build a converter table that looks up the actual date and time the date time serial number represents to make it easier for the users.

 

Thanks for your help.

Waydec