SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am not sure of how to use expression in sharepoint designers. I have a variable called date, but its type string. I am attaching the workflow when an event is created. I need to SET the variable date to the START DATE of the event.

But I need a particular format YYYYMMDD

Something like this maybe:

=YEAR(Current Item:StartTime) + MONTH(Current Item:StartTime) + DAY(Current Item:Start Time)

enter image description here

share|improve this question
or is there any other way to do it? – Esteban V Mar 19 '12 at 15:49
up vote 9 down vote accepted

Using the link at the bottom, I created a designer workflow that will accomplish the above requirement.

*I should also note that ISODatetime should be a string, as well as dateYear, dateMonth, and dateDay

Workflow Overview Concatenation


As for why it is done this way...

SharePoint designer does not support free calculation as you would in say a c# programmed workflow or any type of code solution. In order to do calculations with SPD you have to use the given functions available and only those functions. Any type of calculation similar to the above would just be written out as plain text.

Let me know if you have any questions!

share|improve this answer
Is this possible to do this in 2007? – user10153 Aug 17 '12 at 15:29
It was very helpful, thank you so much for sharing! – user38807 Jan 19 '15 at 18:53

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.