Remove date timestamp

[Anonymous]

Hi all,

May i have the way of removing date timestamp from chart?

Data is as follow

Data source in excel as follow

[isorinrusu]

You can try this either in the Script (recommended) or when using the dimension:

Dimension:

=Date(floor("Date"))

Script:

Date(floor("Date"))        as YourDate

Regards,

Sorin

[Anonymous]

Script is not usable in my environment, as it needs to be used by management. and the solution is also not workable

[YoussefBelloum]

Hi

replace your Date dimension with this:

=Date(Timestamp#(Date,'M/DD/YYYY hh:mm TT'))

[mikaelsc]

remove the continuous axis property (set it to "No")

[Anonymous]

Just as update, none of suggested answer is working. I'm still trying to solve.

[PrashantSangle]

can you show us output of your expression after putting it into calculated field..???

Date(Floor(Date),'M/DD/YYYY')

If possible share your sample app.

Regards,

[eduardo_dimperio]

Date(Floor(YOUR_FIELD))