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? – Luis Valencia Mar 19 '12 at 15:49

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!

| 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 clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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