topic Re: Remove date timestamp in App Development

Remove date timestamp

Anonymous — Wed, 23 May 2018 08:38:25 GMT

Hi all,

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

Data is as follow

Data source in excel as follow

isorinrusu — Wed, 23 May 2018 08:41:57 GMT

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 — Wed, 23 May 2018 08:49:50 GMT

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

YoussefBelloum — Wed, 23 May 2018 09:11:14 GMT

replace your Date dimension with this:

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

mikaelsc — Wed, 23 May 2018 19:53:20 GMT

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

Anonymous — Thu, 24 May 2018 01:57:13 GMT

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

PrashantSangle — Thu, 24 May 2018 06:03:45 GMT

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 — Thu, 24 May 2018 17:23:44 GMT

Date(Floor(YOUR_FIELD))