nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

459347_en-US

liliconcom

Data Filter Date/Time with extra ".0"

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

Scripting

Windows

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

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"

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

Comments

There are no comments yet