- This topic is empty.
- 04/29/2013 at 9:43 am #5406
- 05/03/2013 at 8:34 am #4326
i know that SP date & time format is: MM-DD-YYYY(depending the regional location you have). i have a list that has a column that should be of type date, but the problem i have is that the list should have a format YYYY-MM or MM-YYYY type and as i see, the date type requires of DD wich i don’t need.
i have a calculated column of type date that depends from a column called Year-Month (YYYY-MM, type text) but my boss doesn’t like to use an extra column for this issue, its a shame because it works fine. he would like to have a date column with only YYYY-MM, but i don’t have a clue how to do it.
- 05/03/2013 at 8:34 am #5409
i finally created 2 columns one named Year and the other one named Month, also i created another column that concatenates Year and Month (Year,"-",Month) and i had a calculated column of type date from the column Year-Month.
You must be logged in to reply to this topic.