XL.Date.UnPack
--------------

Unpacks date and time information from double type.

| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
|---|---|---|---|---|---|---|
| [XL](component_XL.md) | [3.5](newinversion35.md) | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |

MBS( "XL.Date.UnPack"; BookRef; Value; Selector ) 

**MBS**( **"XL.Date.UnPack";** /\* Unpacks date and time information from double type. \*/  
**$BookRef**; /\* The reference number for the workbook.e.g. $ref \*/   
**$Value**; /\* The timestamp number.e.g. $t \*/   
**$Selector**) /\* Which component to return.   
Can be year, month, day, hour, minute, second or millisecond.e.g. "year" \*/ 

### Parameters

| Parameter | Description | Example |
|---|---|---|
| BookRef | The reference number for the workbook. | $ref |
| Value | The timestamp number. | $t |
| Selector | Which component to return.    Can be year, month, day, hour, minute, second or millisecond. | "year" |

### Result

Returns number or error.

### Description

Unpacks date and time information from double type.   
### Examples

Unpacks a date:

 $year = MBS ( "XL.Date.UnPack"; $$book ; 41568,83001157407125; "year")  
$month = MBS ( "XL.Date.UnPack"; $$book ; 41568,83001157407125; "month")  
$day = MBS ( "XL.Date.UnPack"; $$book ; 41568,83001157407125; "day")  
$hour = MBS ( "XL.Date.UnPack"; $$book ; 41568,83001157407125; "hour")  
$minute = MBS ( "XL.Date.UnPack"; $$book ; 41568,83001157407125; "minute")  
$second = MBS ( "XL.Date.UnPack"; $$book ; 41568,83001157407125; "second")  
### See also

- [XL.Date.Pack](XLDatePack.md)

This function checks for a license.

Created 18th August 2014 , last changed 3th May 2021

  
[XL.Date.TimeStampToDouble](XLDateTimeStampToDouble.md) - [XL.Font.GetBold](XLFontGetBold.md)

[HTML Version](XLDateUnPack.shtml)