Pipes
2025.9 Pipes
2025.9 Pipes
  • Introduction
  • Configuration
  • Valves
    • API
      • HTTP Response Format Valve
    • Azure
      • Get User
      • Get User Role
      • Is User in Group
    • BankID
      • BidOperation
      • BidToItems
    • Cef event
    • Codecs
      • Base64 Encode
      • Base64 Decode
      • Base64 Converter
    • DateTime
      • Instant Generator
      • Instant Transformer
      • MS Date to Instant Transformer
      • Instant to MS Date Transformer
    • Debug
      • Dump Exports
      • Dump Request
      • Dump Session
      • Dump State
      • Wait
    • Delivery
      • Clean Mobile Valve
      • SMS Valve
      • Voice Valve
      • SMTP Valve
    • EntraID
      • Users
        • Create User
        • Update User
        • Delete User
        • Get User
        • List Users
        • Get Groups
        • List Groups
        • List Direct Reports
        • List Owned Objects
        • Reset Password
      • Groups
        • Create Group
        • Update Group
        • Delete Group
        • List Groups
        • Add Group To Users
        • Remove Group From Users
        • Add User To Groups
        • Remove User From Groups
        • Add Group Owner
        • Remove Group Owner
      • Directory
        • Restore Deleted Item
    • Exports
      • Exports Put
      • Exports Remove
    • Flow
      • Flow Fail
      • Flow State Add
      • Assert Value
      • Pipe Exec
      • Pipe Call
    • Freja
    • HTTP
      • GET
      • PUT
      • POST
      • DELETE
    • Item
      • Item Create
      • Item Merge
      • Item Match Merge
      • Item Remove
      • Items Remove
      • Item Property Add
      • Item Property Copy
      • Item Property Replace
      • Item Property Split
      • Item Property Rename
      • Item Property Hash
      • Item Property Token Replace
      • MV Property To Items
      • JSON To Items
      • MV Property Join
    • JDBC Query
    • JSON
      • JsonObjectCreate
    • JWT
      • CreateJwt
      • ParseJwt
    • LDAP
      • LDAP Search
      • LDAP Group Filter
      • LDAP Bind
      • LDAP Add
      • LDAP Delete
      • LDAP Modify
      • LDAP Move
      • DN Parse
    • Microsoft AD
      • Add Member To Groups
      • Remove Member From Groups
      • Add Group To Members
      • Remove Group From Members
      • GUID to string
    • Misc
      • Basic Auth
    • OTP
      • OTP Generation
      • OTP Validation
    • PKI
      • X509 Certificate Extractor
      • X509 Certificate Validator
      • Passcode Generator
    • PDF
      • Html2Pdf
      • PDFMerge
    • Request
      • RequestParameterExist
      • RequestParameterRename
    • ScriptEval
    • MobilSITHS
    • Session
      • Session Put
      • Session Create
      • CopyFromSession
    • Tokens
      • Token Authentication
    • WorkOrders
      • WorkOrderCreate
Powered by GitBook
On this page
  • Configuration
  • Special handling of 'Never Expires'
  1. Valves
  2. DateTime

Instant to MS Date Transformer

Transforms an existing Instant to a MS Date format.

The Microsoft (MS) date format represents dates as the number of 100-nanosecond intervals (also known as ticks) that have elapsed since January 1, 1601, UTC. This date is known as the MS epoch and is used extensively in Windows systems, including file times and Active Directory attributes like accountExpires.

Configuration

Valve name: InstantToMsDateTransformer

Name
Description
Default value
Mandatory
Expanded

src

Property containing the source Instant.

N/A

src_pattern

Instant pattern. ISO-8601 format

"yyyy-MM-ddTHH:mm:ss.ffffffZ"

src_tz

Instant time zone.

"UTC"

dest

Property containing the created MS Date

N/A

remove_existing_dest

Flag to remove any value pre-existing in destination-property. To avoid creating a multi-value property.

false

{
    "name": "InstantToMsDateTransformer",
    "config": {
        "src": "instant",
        "src_pattern": "yyyy-MM-ddTHH:mm:ss.ffffffZ",
        "src_tz": "GMT-1",
        "dest": "ms_date"
    }
}

Special handling of 'Never Expires'

If the src value is "0" the valve interprets this as an account that never expires. In this case, the output at dest will be set to 9223372036854775807 (0x7FFFFFFFFFFFFFFF)

PreviousMS Date to Instant TransformerNextDebug