0

Intent: To create a calculated column that shows the date ONLY from date and time column type. I created a formula, but it is wrong and not sure where I am going wrong. Can anyone help? Note: I cannot change the column type to display 'Date' only. I need to keep this column so creating a new column date column is not an option

=TEXT(Start Date,"dddd")

1

Try this

= TEXT([Start Date],"d/m/yyyy")

enter image description here

Output

2/9/2016

enter image description here

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.