# 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://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FXWdRseJzbpiUW7lTYloo%2F0.png?alt=media" 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://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FMd13BmdPlsWsGcJ24v2W%2F1.png?alt=media)

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://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FGdwVeIMbOrTieEfKWBG8%2F2.png?alt=media)