Scribe for Excel to Microsoft CRM 2011: Date Values

Question:

When using Scribe to import data into MIcrosoft CRM 2011 organization from Excel, sometimes date values need to be pull into strings (e.g. ensuring unique names) with the serial number Excel stores for the values. This often happens when I use Functions. I just want the date, how do I get it?

Answer:

Create a calculated user variable and build it with DATEPART:

 DATEPART (“m”, < ColumnId >) & “/” & DATEPART (“d”, < ColumnId >) & “/” & DATEPART( “yyyy”, < ColumnId > ) 

Now, you can happily append that to your string and it will be a regular human readable date.

Phone: 312-602-4000
Email: marketing@westmonroepartners.com
222 W. Adams
Chicago, IL 60606
Show Buttons
Share On Facebook
Share On Twitter
Share on LinkedIn
Hide Buttons