Thursday, November 03, 2011 3:37 AM
Is there a way to change the date format from Object (year,month,day)? Basically, what I want is to format the date by YYYYMMDD. Currently the output I have is 2011113 (nov 3, 2011), but what I want is 20111103. Thanks
Thursday, November 03, 2011 6:13 AMHi, have you tried to use the Format Date/Time activity? You can specify input and output in anyway with that activity.
Anders Bengtsson | Microsoft PFE | blog at http://www.contoso.se
Thursday, November 03, 2011 10:25 AMWhen you work with "Format Date/Time" (Utilities-Section) the Output-Format should be yyyyMMdd (case sensitive!).
Friday, November 25, 2011 10:14 AMModerator
As this thread has been quiet for a while, we assume that the issue has been resolved. At this time, we will mark it as "Answered" as the previous steps should be helpful for many similar scenarios.
In addition, we’d love to hear your feedback about the solution. By sharing your experience you can help other community members facing similar problems.
Yog Li -- Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
Tuesday, January 17, 2012 7:51 AM
Maybe a better way and to keep the objects to a minimum, use nested functions:
in this case if there is one digit. it will ad a zero in front of it.