Data Filter Date/Time with extra ".0"

[#1]

I have a column with a Date and Time in it (see graphic for formatting).  When I use a Global or Local Data Filter, the dates/times show up as MM/DD/YY H:M:S.0 with the ".0" being extraneous (see graphic for data filter).

Does anyone know how to get rid of the ".0" in the data filter?

Thanks

[#2 · Accepted solution]

If you set the following Custom Format for you date column, the Local Data Filter will drop the .0

Char( Format( :value, "m/d/y" ) ) || " " || Char( Hour( :value ) ) || ":" || Char( Minute( :value ) ) || ":" || Char( Round( Second( :value ) ) );

[#3]

 Thanks @txnelson, I will try that. But it appears you are saying I need a new "second" date column for this to work - is that correct?  I guess another way to approach this is to use a For Each Row and replace the data that is there with this new value.

Martin

[#4]

You do not need a new column.  Second() is just a function that extracts the number of seconds value from the Date/Time column

Attached is the example data table I used for my last response