Tagged with datetotext - Visokio Forums http://forums.visokio.com/discussions/tagged/datetotext/feed.rss Mon, 30 Oct 17 16:12:06 -0400 Tagged with datetotext - Visokio Forums en-CA Date/Time: DateToText Function, using "yyyy" and not "YYYY" http://forums.visokio.com/discussion/2885/datetime-datetotext-function-using-yyyy-and-not-yyyy Wed, 25 Mar 2015 14:08:27 -0400 benjamin 2885@/discussions Using the DatetoText function results in errors when you use dates near the end of the year (anywhere from the the 29th-31st of Dec)
Example :
DATETOTEXT(date(2013,12,31),"YYYY")

Thanks, Ben]]> Date/Time: How to display day of week? http://forums.visokio.com/discussion/2796/datetime-how-to-display-day-of-weeks Fri, 19 Dec 2014 10:38:57 -0500 cristian 2796@/discussions I want to create a chart that has days 1-31 on the x-axis. Aggregation is on sales amount. I have a table with transactions for each day for a complete year and I want to show the sales per day regardless of month. Is there a date function that extracts the day of the date? I tried to use the Expand Values block but I can't choose my date field in "Field selection" of the block. Any suggestions?

Br
Cristian]]>