- Print
- DarkLight
- PDF
Can you format the date field in a data grid?
Article summary
Did you find this summary helpful?
Thank you for your feedback
I need to get to the month value in a date in a data grid so I can send out anniversary cards. Is this possible?
Answer:
It is possible to parse the date in a datagrid to get to the day, month and year components.
Open the desired data grid and click the View Settings button. When you are selecting the fields you want included on your data grid you are working on the Columns tab.
Open the desired data grid and click the View Settings button. When you are selecting the fields you want included on your data grid you are working on the Columns tab.
- Select a date field from the left side column.
- The Date Functions button will become active.
- Before clicking the Add button to add the field to a column in your data grid, click the Date Functions button and select either Year, Month, Day, CharMonth, or ShortCharMonth.
- If you click on Year , for example, you would be adding another column alongside of the paydate column to show the year.
- Paydate of 05/15/2010, year 2010 would display in your data grid.
- If you click on Year , for example, you would be adding another column alongside of the paydate column to show the year.
- For your other choices:
- Month will display the period number in a separate column.
- For example, paydate of 11/04/2004, you will see "11" in a separate column.
- Day will display the day in a separate column.
- For example, paydate of 11/04/2004, you will see "4" in a separate column.
- CharMonth will spell out the month If your period 01 is January then you will have an additional column with January populating the field.
- ShortCharMonth will display the period month as abbreviated.
- Again, if your period 01 is January than you will have an additional column with Jan populating the field.
- Month will display the period number in a separate column.
Was this article helpful?