Input data time field 14/11/2020 11:15:54

[ericet]

Hello everyone,

I need to create Input date time field example "14/11/2020 11:15:54"

so that I can get the start data time for a report.

I want to be able to type it in ? or something close

Any ideas ?

Eric

[v-stephen-msft]

Hi @ericet ,

I think you may want to find the exact date from the slicer to filter. You can try to use Advanced filtering from Filters.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ericet]

Maybe the date serial number could be the solution ?

How do I find the serial number of a date ?

Eric

[Anonymous]

@ericet - If I am understanding your point, you want to change the data type of the date column

Change the format of the date column to Date/Time

Appreciate your kudos!! Mark my post as solution if this helps.

[ericet]

No that's not what I mean.

I need the user to be able to Input date time field example "14/11/2020 11:15:54"

Is it posiblle to have a slicer that includes date time ?

Eric

[Anonymous]

Possible workaround is-

Two tables for Hour and two tables for Minute. I would suggest creating two time table instead. Please refer to the snapshot below.

startTimeTable =
GENERATESERIES ( TIME ( 0, 0, 0 ), TIME ( 23, 59, 0 ), TIME ( 0, 1, 0 ) )

Make sure the date format should be MM/DD/YYYY HH:MM:SS

Appreciate your kudos!! Mark my post as solution if it helps.