Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I am using a workflow for a calendar. In workflow email I use [%Current List:Start Time%] and [%Current List:End Time%] for the events. But the date is always displayed as "Monday, January, 01, 0001".

How to fix this? How to insert a specific column from a list to insert in a workflow email?

share|improve this question
    
It should be current item:start time and current item:end time, where are you getting those fields? –  PirateEric Apr 30 '13 at 4:55
add comment

2 Answers

up vote 2 down vote accepted

Your issue is related to that these fields are empty. If you want to use Start and End time of the item workflow is started on, you should use Data Source = "Current Item" instead of "Current List" and it should work.

share|improve this answer
    
@MikhaliSP but it did not work for start time. But end time works fine. –  Gravity M Apr 30 '13 at 19:19
    
Are you sure that the Start Time field is filled at the time the email is sent? Try to add the log activity with this field to make sure that it is not empty –  MikhailSP Apr 30 '13 at 19:36
    
How to add log activity with the field? –  Gravity M Apr 30 '13 at 20:23
    
Just place cursor before email activity and start typying "log". Then press Enter (Log activity adds), press underlined word "Message", and button "...". After that in the String Builder press Add Lookup and select Current Item/Start Time. Press ok. After republishing and runing WF, in workflow history Start Time value will be shown. –  MikhailSP May 1 '13 at 10:11
    
It didn't solve the problem. I added the start time log before the email. But it still shows that 0001 date. –  Gravity M May 1 '13 at 16:23
show 1 more comment

enter image description here

Check This Different Formats Working fine.

Output is Short Date 5/1/2013 String 5/1/2013 11:00:00 AM long date Wednesday, May 01, 2013.

share|improve this answer
add comment

Your Answer

 
discard

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.