# ToJulianDayNumber (DateTime)

| **Name**    | ***ToJulianDayNumber***                                                                                                                          |
| ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------ |
| Syntax      | ToJulianDayNumber (Date dateTime)                                                                                                                |
| Purpose     | To convert a date to a Julian day number.                                                                                                        |
| Description | Returns an integer representing Julian day number for the specified date time. This function discards the time component of the date time value. |
| Return Type | Int64                                                                                                                                            |
| Parameter   | dateTime \[System.DateTime] – DateTime object for which the Julian day number will be returned                                                   |

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FROiM0V5XqEGMZ0gHL5Rd%2F0.png?alt=media)

**Example**

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

Where,

*dateTime* ­= 04/10/2020 10:10:25 AM

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2F8RIkHmsnhRfhq94MKUYH%2F1.png?alt=media)

In the output window, you can see that the provided value has been converted into a Julian day number.

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FAajklEWFbu0hshf2kwop%2F2.png?alt=media)