# DateToJulian (DateTimeWithOffset dateTime, Integer length)

| **Name**    | ***DateToJulian with Offset***                                                                                       |
| ----------- | -------------------------------------------------------------------------------------------------------------------- |
| Syntax      | DateToJulian (DateTimeWithOffset dateTime, Integer length)                                                           |
| Purpose     | To convert the given date time offset value to Julian format of specified length.                                    |
| Description | Convert the given date time offset value to Julian format.                                                           |
| Return Type | String                                                                                                               |
| Parameters  | <p>dateTime \[System.DateTimeOffset] – Date Time object to be converted into Julian</p><p>length \[System.Int32]</p> |

**Example**

<figure><img src="https://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/0%20(139).png" alt=""><figcaption></figcaption></figure>

In this example, we will pass a date time offset value and an integer value to the function transformation object using a *Variables* object.

Where,

*dateTime* = 05/06/2014 12:00:00 AM +05:00

*length* = 5

![](https://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/1%20\(140\).png)

In the output window, you can see that the provided date time offset value has been converted into Julian format of the specified length.

![](https://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/2%20\(140\).png)