TIBCO Spotfire

Hi All, I have a very quick question: Does the starting day for the "Week" function depend on the client or server, when using the web player client? If it is depentend on the client, does anyone know of a method to force it to start on a Monday, assuming the start day of the client's regional...

Hi! I'm using Spotfire 3.2.2 desktop, I have a 'Created Date' column in my database, and a Created By filter on the my page. I want the filter on my page to update automatically, and only records created in the last 3 months to display. I don't want the user to have to change this every...

Our company is running SF 3.2.2.4. Web Player version 3.2.2. I created a presentation pulling data from our server using the info links and put the output on the web player. The data includes incidents within our company that occurred year-to-date. When I open the data in my web player the date format...

I’m trying to create two Column Elements for an information link that calculates the week start (Monday) and week end (Sunday) date for a date column in my table, but I can’t seem to get the expression written correctly. Does anyone know what the correct expressions would be to calculate these two new...

Hi all, I want to convert a text column in date. The format of text is 'DD/MM/YYYY'. How can I specify the format of the date while using the date conversion function. By Default it takes only one argument. When I use date function with one argument and pass my text column to it, the spotfire...

I have a list of items which have a start and an end date. I'd like to visualize how many items are active in any one month/quarter/period (say, a bar chart with month/quarter on X axis, count on Y). The challenge I'm finding is that a item with a start date of Jan and end date of March is active...

hi there, i am just trying to do a simple calculated column - to find the diff between a date column and a static date... how do i write in the static date? datediff('day',[loan_orig_date], 20/01/2011) i have tried a few ways to write 20th january 2011..but none seem to work..what is the correct...

Hi, I am trying to create a column that will return the next date value in a list, in order to calculate the days since the previous date value. My data contains all the dates in one column, like this: Business Incident Date 1 01/28/2011 20:30 1 02/02/2011 14:15 2 02/03/2011 11:30 1 02/05/2011 9:15 1...

Is there any way to have the user select "last month", "last year" etc from a drop down box. I can't seem to figure out how to program this into a property control. Thanks, Michael

Hey Per, Thanks for the help! The link that you gave me contains a date function which will convert the text to date but again in the format MM/DD/YYYY. I have a text field which contains month IDs like MMMYY eg:- Mar10, Jan09 etc. If I give Date(Mar10) gives me 3/1/2010. But, I want it in same way(MMMYY...