Stop showing time in bar charts

0
Hi everyone!   Right now I’m having this problem in my app where in some charts a time stamp is also showed, like this:   But it shouldn’t be like this, I just need the date, like this:   I have this problem in 3 out of 4 graphs, I checked and the charts and apart from the microflows that passes the info, are identical, configuration, series, data points. I thought maybe is the info that I’m using, it comes from an excel file that I import, but it doesn’t have a time, just a date so I really don’t know what’s happening.    Is there a way to stop showing the time? 
asked
2 answers
1

As Kenya said, this is a date formatting issue.  FYI, in Mendix, all date values include a time component.  Since there is no time specified in the spreadsheets you are importing, the time is set to midnight.

 

As a rule, I create a string attribute for dates used when creating charts.  In your case, I would create a string variable for the X Axis labels and populate that with the date values formatted the way you want them.  You can still sort by the date attribute, so that the sequence of the bars is correct, but using a string attribute provides you with control over the display and formatting of date values.

answered
0

Hi Kenya Castellanos,

Check if the Attribute for X axis value is String. if string checks how the date formatting is done for those graphs. 

You can use format date time string functions to format your date to show how you require.

https://docs.mendix.com/refguide/parse-and-format-date-function-calls/#3-formatdatetimeutc
 

answered