Skip to content
DataMiner DoJo

More results...

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Search in posts
Search in pages
Search in posts
Search in pages
Log in
Menu
  • Blog
  • Questions
  • Learning
    • E-learning Courses
    • Open Classroom Training
    • Certification
      • DataMiner Fundamentals
      • DataMiner Configurator
      • DataMiner Automation
      • Scripts & Connectors Developer: HTTP Basics
      • Scripts & Connectors Developer: SNMP Basics
      • Visual Overview – Level 1
      • Verify a certificate
    • Tutorials
    • Video Library
    • Books We Like
    • >> Go to DataMiner Docs
  • Expert Center
    • Solutions & Use Cases
      • Solutions
      • Use Case Library
    • Markets & Industries
      • Media production
      • Government & defense
      • Content distribution
      • Service providers
      • Partners
      • OSS/BSS
    • DataMiner Insights
      • Security
      • Integration Studio
      • System Architecture
      • DataMiner Releases & Updates
      • DataMiner Apps
    • Agile
      • Agile Webspace
      • Everything Agile
        • The Agile Manifesto
        • Best Practices
        • Retro Recipes
      • Methodologies
        • The Scrum Framework
        • Kanban
        • Extreme Programming
      • Roles
        • The Product Owner
        • The Agile Coach
        • The Quality & UX Coach (QX)
    • DataMiner DevOps Professional Program
  • Downloads
  • More
    • Feature Suggestions
    • Climb the leaderboard!
    • Swag Shop
    • Contact
      • General Inquiries
      • DataMiner DevOps Support
      • Commercial Requests
    • Global Feedback Survey
  • PARTNERS
    • All Partners
    • Technology Partners
    • Strategic Partner Program
    • Deal Registration
  • >> Go to dataminer.services

DateTime set parameter best practice

Solved1.18K views12th January 2021parameter measurement type
5
Mário Ferreira [SLC] 23rd December 2020 1 Comment

Hi,

According to this link:

DataMiner Development Library

parameters of type datetime should use the method ToOADate() when the intention is to set one parameter with a DateTime value on Dataminer.

During a test, I have set a parameter directly with a DateTime value without calling the method ToOADate() and the results were the same. What's the difference between those two approaches?

The following picture shows the code realized:

Mário Ferreira [SLC] Selected answer as best 12th January 2021
Thijs Vanovenacker [SLC] [DevOps Advocate] commented 23rd December 2020

Interesting question Mario.
Personally I’m always passing the double value along. “dateTimeObj.ToOADate()”
The fact that it also works passing the full DateTime object along, is probably because the software is capable to cope with that and convert it internally.

It would indeed be good to hear if there are any downsides or what the preferred way would be to offload these DateTime values.

1 Answer

  • Active
  • Voted
  • Newest
  • Oldest
8
Wouter Demuynck [SLC] [DevOps Advocate]5.91K Posted 24th December 2020 1 Comment

The SLProtocol process in DataMiner mainly works with strings and double values.

Setting the value to a DateTime from a QAction works because SLProtocol will try to invoke a conversion to the target type (double/VT_R8) if the source type doesn't match (VT_DATE). This specific conversion only gets applied for sets coming from QActions.

As a general advise, it's probably best to always use .ToOADate() and not rely on any magic conversions.

Mário Ferreira [SLC] Selected answer as best 12th January 2021
Avatar photo
Jan Staelens [SLC] [DevOps Advocate] commented 7th January 2021

Checking if .ToOADate() was used for dates is actually part of our quality control on protocols written within SLC.
For clarity and stability it’s an important rule to follow.

Please login to be able to comment or post an answer.

My DevOps rank

DevOps Members get more insights on their profile page.

My user earnings

0 Dojo credits

Spend your credits in our swag shop.

0 Reputation points

Boost your reputation, climb the leaderboard.

Promo banner DataMiner DevOps Professiona Program
DataMiner Integration Studio (DIS)
Empower Katas

Recent questions

Multiple Set on Table parameters for DVE’s 0 Answers | 0 Votes
DOM Definition relations returned in Definition query 0 Answers | 0 Votes
Alarm Dashboard PDF/CSV Export 1 Answer | 0 Votes

Question Tags

adl2099 (115) alarm (62) Alarm Console (82) alarms (100) alarm template (83) Automation (223) automation scipt (111) Automation script (167) backup (71) Cassandra (180) Connector (108) Correlation (68) Cube (150) Dashboard (194) Dashboards (188) database (83) DataMiner Cube (57) DIS (81) DMS (71) DOM (140) driver (65) DVE (56) Elastic (83) Elasticsearch (115) elements (80) Failover (104) GQI (159) HTTP (76) IDP (74) LCA (152) low code app (166) low code apps (93) lowcodeapps (75) MySQL (53) protocol (203) QAction (83) security (88) services (51) SNMP (86) SRM (337) table (54) trending (87) upgrade (62) Visio (539) Visual Overview (345)
Privacy Policy • Terms & Conditions • Contact

© 2025 Skyline Communications. All rights reserved.

DOJO Q&A widget

Can't find what you need?

? Explore the Q&A DataMiner Docs

[ Placeholder content for popup link ] WordPress Download Manager - Best Download Management Plugin