## On this page

  

 

 # Add Date, Integer and Logical data 

 Last update: 16.07.2025 

Work with date, integer, and logical attribute types.

## Connect to MI

Get a database and table.

```python
from datetime import datetime
from GRANTA_MIScriptingToolkit import granta as mpy

mi = mpy.connect('http://my.server.name/mi_servicelayer', autologon=True)
db = mi.get_db(db_key='MI_Training')
db.unit_system = 'Metric'
db.absolute_temperatures = False
tab = db.get_table('AM Builds')

```

## Create a new record and path

Define a path in the table from a starting folder (in this case the top level folder) using `path_from()`. If the path does not exist, the required folders will be created. Specify `end_node` to create a new **Record** object at the end of the path with that name.

```python
now = datetime.now().strftime("%c")
record_name = 'STK Example 13:{}'.format(now)
record = tab.path_from(None, tree_path=['Blown Powder (Laser beam)', 'Ti-6Al-4V'], end_node=record_name)
record, record.parent

```

*Previous cell output:*

```output
(<Record long name: STK Example 13:Wed Oct 30 16:08:10 2024>,
 <Record long name: Ti-6Al-4V>)

```

## Edit the record's attributes

Fetch date, integer and logical attributes for editing.

```python
tab.bulk_fetch([record], attributes=['Date of Beam Profile Diagnostic',
                                     'Date of Build',
                                     'Maximum Number of Layers',
                                     'Built in Closed Chamber?'])
diagnostic_date = record.attributes['Date of Beam Profile Diagnostic']
build_date = record.attributes['Date of Build']
number_of_layers = record.attributes['Maximum Number of Layers']
closed_chamber = record.attributes['Built in Closed Chamber?']

```

### Date attributes

Use the `value` property to set the date value of the attribute with either a **datetime** object or a properly formatted string.

```python
diagnostic_date.value = '2020-07-12'
build_date.value = datetime.now()

```

### Integer attributes

Use the `value` property to set the integer value of the attribute.

```python
number_of_layers.value = 5

```

### Logical attributes

Use the `value` property to set the logical value of the attribute.

```python
closed_chamber.value = True

```

## Write your changes to MI

First, specify the attributes on the record which you want to update on the server. Then write the changes to MI. The list of updated **Record** objects is returned.

```python
record.set_attributes([diagnostic_date, build_date, number_of_layers, closed_chamber])
record = mi.update([record])[0]

```

## Output the record's attributes

Access the attribute values via the same properties you used to assign them.

```python
datetime_format = "%b %d %Y"
diagnostic_date = record.attributes['Date of Beam Profile Diagnostic']
print("Date of Beam Profile Diagnostic: {0}".format(diagnostic_date.value.strftime(datetime_format)))

build_date = record.attributes['Date of Build']
print("Date of Build: {0}".format(build_date.value.strftime(datetime_format)))

number_of_layers = record.attributes['Maximum Number of Layers']
print("Maximum Number of Layers: {0}".format(number_of_layers.value))

closed_chamber = record.attributes['Built in Closed Chamber?']
print("Built in Closed Chamber?: {0}".format('Yes' if closed_chamber.value else 'No'))

```

*Previous cell output:*

```output
Date of Beam Profile Diagnostic: Jul 12 2020
Date of Build: Oct 30 2024
Maximum Number of Layers: 5
Built in Closed Chamber?: Yes

```