workitem field type date time custom formats

Question

I have a requirement that a field has to show only date than date time, some thing like MM/dd/yyyy format.

Please help me on achieving this.

Thanks,

Raghusrikanth

Answer 1

Hi,

You can look at the Issue work items definition for the Due Date for example:

                <Control FieldName="Microsoft.VSTS.Scheduling.DueDate" Type="DateTimeControl" Label="D&amp;ue Date:" LabelPosition="Left" Format="Short" />

---

Please remember to mark the replies as answers if they help. --- Success, Damir

Answer 2

Hi Raghusrikanth,

Thank you for your post.

I suppose you just want a field just display date not include time. Please choose DateTimeControl for this field, not FieldControl.

When you edit the WIT, in Field Definition, please select Date Time type. Then, the most inport thing is in Layout tab, please select DateTimeComtrol, do not set FieldControl. You will just see the date not include time.

Best regards,

---

Lily Wu [MSFT]
MSDN Community Support | Feedback to us

Answer 3

Hi Lily,

I Am using date time control only, but when I search the WI using WIQL the out put will be date+time and same when exported to Excel.

Is there any way to fix this whil exporting to excel?

Thanks,

Raghusrikanth

Answer 4

Need to know too.

Thanks,

Answer 5

Hi Raghusrikanth,

Try to set Excel Format Cells.

Best regards,

---

Lily Wu [MSFT]
MSDN Community Support | Feedback to us