format object date
-
Thursday, November 03, 2011 3:37 AM
Hi,
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
All Replies
-
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 AM
When you work with "Format Date/Time" (Utilities-Section) the Output-Format should be yyyyMMdd (case sensitive!).- Edited by StefanHorzMicrosoft Community Contributor Thursday, November 03, 2011 10:26 AM
- Marked As Answer by Yog LiMicrosoft Contingent Staff, Moderator Friday, November 25, 2011 10:14 AM
-
Friday, November 25, 2011 10:14 AMModerator
Hi,
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.
Thanks,
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
Hi,
Maybe a better way and to keep the objects to a minimum, use nested functions:
[Right('0{Object end time (seconds) from "Run Program"}',2)]in this case if there is one digit. it will ad a zero in front of it.

