Profile Picture

DateTime Formatting

Posted By Thomas Streitferdt 2 Years Ago
Author
Message
Thomas Streitferdt
Posted 2 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)

Group: Forum Members
Last Active: 2 Years Ago
Posts: 3, Visits: 38
Hello,
I need to configure my date time format. Now it returns the values in "3/1/2010 12:00:00 AM" but I only want to get the month like "03" or "March".
I already tried to change it by using following description: http://support.nevron.com/KB/a192/configure-the-chart-web-part-date-time-axis-label-formatting.aspx
Unfortunately that doesn`t work! Is there a simple solution for that problem? Is it possible using the expression editor to change the format?
 
Thanks a lot

Nevron Support Team
Posted 2 Years Ago
View Quick Profile
Supreme Being

Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)

Group: Moderators
Last Active: 2 days ago @ 8:33 AM
Posts: 2,593, Visits: 2,279
We have added full support for date time formatting in newer versions of the chart (after the Knowledgebase article was published), so now you do not need to write custom code to achieve your formatting goal. Follow these steps:

1. Set the PrimaryX axis scale to Date Time
2. In the Label Formatting group box, change the Formatting Mode to Fixed
3. In the Label Format field enter the desired date time label format. For a description of the date time formatting string refer to this topic in the documentation:
Resources > Date Time Format Strings


Best Regards,
Nevron Support Team



Thomas Streitferdt
Posted 2 Years Ago
View Quick Profile
Forum Newbie

Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)Forum Newbie (0 reputation)

Group: Forum Members
Last Active: 2 Years Ago
Posts: 3, Visits: 38
Thanks for the support. The problem was that the Scale Mode was set to Automatic. I changed it to Numeric and now it works but I got another problem.

My settings now are

1. PrimaryX axis scale is Date Time
2. Formatting Mode is Fixed
3. My desired date time label format is yyyy-MM

Now it returns
1900-01, 1900-03 etc. in the preview. But my date time starts on 3/1/2010 and not on 1/1/1900.

Now my question is: Where do I change the settings to get the Date Times from 3/1/2010 until now? And not from 1st January 1900? I know why that happens but I don`t find the settings to change the formats...

Thank you in advance


Nevron Support Team
Posted 2 Years Ago
View Quick Profile
Supreme Being

Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)Supreme Being (3,273 reputation)

Group: Moderators
Last Active: 2 days ago @ 8:33 AM
Posts: 2,593, Visits: 2,279
Hi,
The X axis in numeric mode will automatically scale your data range. Perhaps you indeed have a 1/1/1900 date or invalid date in your data set. You can however specify a fixed axis scale from the Axis - Range tab - there in the Begin and End fields you can enter a manual range of the axis.


Best Regards,
Nevron Support Team





Similar Topics


Reading This Topic