topic Re: Data Filter Date/Time with extra ".0" in Discussions

Data Filter Date/Time with extra ".0"

Martin — Fri, 09 Jun 2023 18:10:22 GMT

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

Re: Data Filter Date/Time with extra ".0"

txnelson — Tue, 08 Feb 2022 21:03:21 GMT

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 ) ) );

Re: Data Filter Date/Time with extra ".0"

Martin — Tue, 08 Feb 2022 21:08:57 GMT

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

Re: Data Filter Date/Time with extra ".0"

txnelson — Tue, 08 Feb 2022 21:20:38 GMT

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