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

  • or is there any other way to do it? Commented Mar 19, 2012 at 15:49

1 Answer 1


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!

  • Is this possible to do this in 2007?
    – user10153
    Commented Aug 17, 2012 at 15:29
  • It was very helpful, thank you so much for sharing!
    – user38807
    Commented Jan 19, 2015 at 18:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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