http://forums.visokio.com/discussions/tagged/concatenate-text/feed.rss Mon, 30 Oct 17 20:04:55 -0400 Tagged with concatenate-text - Visokio Forums en-CA http://forums.visokio.com/discussion/1979/datetime-importing-from-dart-and-salesforce-issues Thu, 10 Jan 2013 15:05:33 -0500 cgamolo 1979@/discussions
We are running into a few issues with the date fields from 2 data sources.

DART and DATE
We are connecting to DART and have a DATE field. Based on the Field Organizer, the original format of the DATE comes in as Category. We want to convert this to use a Date/Time format (so that we can run some formulas later on), however, when choosing the Date/Time option in the drop down, it blanks out the entire date entry. I believe we've used this function before, so not sure why this is removing the date entries now.

How can we ensure that a date is read as a date?


SALESFORCE and DATE
We are connecting to Salesforce and also have a DATE field. Based on the Field Organizer, the original format of the DATE comes in as Date/Time. The date format is defined as yyyy-MM-dd and this is displaying properly in the preview. We want to concatenate this date with another column, however, when we do this, the date formatting is being converted to a very long string.

Ex. Start_Date= 2013-01-01
End_Date = 2013-01-31
Campaign_Name = XXX

Formula: [Campaign_Name]+ " ("+[Start_Date]+" - "+[End_Date]+")"

Result: XXXX (Tue Jan 01 00:00:00 EST 2013 - Thu Jan 31 00:00:00 EST 2013)

How can we keep it so that what we concatenate is the same as what is being displayed?



Please let me know if you need additional information to further investigate.

Thanks,
Catherine]]> http://forums.visokio.com/discussion/1939/formulae-concatenating-text-valuess Thu, 06 Dec 2012 06:57:35 -0500 Phillipa 1939@/discussions
I have 2 fields which contain text (product names). I would like to combine these 2 fields into one with comma separation so that I can show a pie chart of all the product names and how often they occur.

I think I would then have to tokenise the fields............but am not quite sure of the easiest way around this.

Please could someone help!!

Thanks, Phillipa]]>