- Minitab Cookbook
- Isaac Newton
- 231字
- 2021-07-16 12:29:19
Extracting values from a date/time column
Often, it can be useful to find values such as day, month, or hour of the day from a date column. This can help later on while trying to find out about the variation in our results, finding effects based on day of the week or month of the year.
Getting ready
The data column displayed in the following screenshot shows dates in the mm/dd/yyyy format. To run this recipe, type the following data into a new column and label the column as Date. We will then create a new column displaying the months from the dates.
How to do it…
The following steps will create a column for the month from the dates in the worksheet:
- Navigate to Data | Extract from Date/Time | Extract to Text.
- In the dialog box, enter the date column in the Extract from date/time column section. Enter
Monthinto the Store text column in section. - Tick the Month selection and click on OK.
How it works…
If the worksheet does not contain a column called Month already, it will create a new column for us. The selected fields will then populate this column in the worksheet. The Extract to Text option will create months and days of the week by their names, where the Extract from date/time to Numeric option will create a column of numbers.
- 自愿審計動機與質量研究：基于我國中期財務報告審計的經驗證據
- Microsoft Dynamics NAV Financial Management
- Citrix? XenMobile? Mobile Device Management
- 會計信息化基礎（金蝶版）
- Learning Informatica PowerCenter 9.x
- 審計實務案例與實訓教程
- OAuth 2.0 Identity and Access Management Patterns
- 審計全流程實操從入門到精通
- 風險導向審計準則實施效果研究
- Learn Power Query
- 政策建模技術：CGE模型的理論與實現
- 審計學理論與實務
- Instant Windows PowerShell Guide
- 中國重點經濟領域統計分析
- 獨立審計質量的激勵治理模式研究