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.