Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
About date ranges
Suchandra
Can anyone help me in this...
From database, the date value is coming in the string format as range 'MM/dd/yy , MM/dd/yy' i.e '01/01/08,12/31/08'. How can I format it to show it in the way 'Jan 01, 2008 to Dec 31, 2008'
Find more posts tagged with
Comments
mwilliams
Hi Suchandra,
The only way I can think of to do that would be to separate the input string at the ',' and change it from a string to a date. Format the dates the way you want them and then add it back together as a string with "to" added in between them.
Hope this helps.