Skip to Content

SiePortal

The integrated platform for your product selection, buying and support workflow - bringing together Industry Mall and Online Support.

SiePortalDeutsch

Search

Home
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menu temporary not available
- Menue temporary not available
- {{item.title}}

Products & Services
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Support Support
{{(apiData.Support | filter:{'rank':1}:true)[0].title}} Support
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
MySiePortal MySiePortal
{{(apiData.MySiePortal | filter:{'rank':1}:true)[0].title}} MySiePortal
- Menu temporary not available
- Menue temporary not available
- {{item.title}}
Cart ({{apiData.CartCount}})

Navigation

Elapsed days between 2 DT vars

Created by: cbcX at: 12/28/2009 6:00 PM (9 Replies)

Rating (2)

Thanks 2

10 Entries

12/28/2009 6:00 PM	Rate (0)
cbcX Posts: 43 Rating: (0)	Hi, I am trying to write or find a function or FB that will calculate the number of days elapsed between 2 DATE_AND_TIME vars. I have done something similar in S7-200 Microwinbut I seem to be banging a wall trying to do it in Step 7 (300). Specifically I have having trouble accessing the individual bytes of the DT var in a function. Can anyone provide some direction? Or maybe tell me how to convert the DT to milliseconds? There may be as much as 1-2 months between the 2 dates. Or is there a source for a library that will help with this? Thank you...
cbcX Posts: 43 Rating: (0)
Suggestion To thank Quote Answer

12/29/2009 8:53 AM	Rate (0)
Aret Posts: 2348 Rating: (265)	Standart Functions-> SB_DT_DT
Aret Posts: 2348 Rating: (265)
Suggestion To thank Quote Answer

12/29/2009 2:53 PM	Rate (0)
cbcX Posts: 43 Rating: (0)	Thank you very much!
cbcX Posts: 43 Rating: (0)
Suggestion To thank Quote Answer

12/30/2009 4:03 AM	Rate (2)
Sydney Gold Member Joined: 1/4/2008 Last visit: 12/22/2025 Posts: 703 Rating: (98)	Aret Standart Functions-> SB_DT_DT Hello, this one is ok, but the result isTIME which has the maximum less than 25 days. You wrote about two months soI would ratheruse the FC6 "DT_DATE" function from the IEC folder of the Standard library to convert both DTs to DATEs- it's stored as an unsigned integer in units of days, with day 1 equal to Jan. 1, 1990. These values can be subtracted then. BUT the results will differ! If you use SB_DT_DT, the result is accurate TIME format, if you use my suggestion it will subtract the dates, i.e. the whole daysaccording to date so the solution depends on which result you need. If you need a time difference independent from date and range more than 25 days,you'll have to make something more difficult (combination of a date subtraction and then atime of day difference). Regards Sydney

Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users H-H

12/30/2009 1:55 PM	Rate (0)
Aret Posts: 2348 Rating: (265)	Nice point, Sydney!^)
Aret Posts: 2348 Rating: (265)
Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users Sydney

1/4/2010 2:26 PM	Rate (0)
cbcX Posts: 43 Rating: (0)	Thanks to all who responded. I actually ended up writing my own function which works perfectly. I may take a look atSydney's solution because 1-day resolution is fine for what I am doing but yes a 25 day span is definitely not enough. Again Thanks!
cbcX Posts: 43 Rating: (0)
Suggestion To thank Quote Answer

1/4/2010 4:49 PM	Rate (0)
cbcX Posts: 43 Rating: (0)	Looking at Sydney's solution, I used FC 6 to convert the DT vars to DATE vars. But what function can subtract 2 DATE Vars? Do I need to convert them to (d)integers first?
cbcX Posts: 43 Rating: (0)
Suggestion To thank Quote Answer

1/4/2010 6:11 PM	Rate (0)
Sydney Gold Member Joined: 1/4/2008 Last visit: 12/22/2025 Posts: 703 Rating: (98)	Hello, as I wrote, the DATEis stored as an unsigned integer in units of days so you don't need to convert it.Depends which programing language you use, in STL you can do it directly, in LAD/FBD you have to firstly MOVE it to INT variable (could be in TEMP area) or switch-off the Type Check of Addresses in editor settings (but I don't suggest this). Regards Sydney

Suggestion To thank Quote Answer

1/4/2010 8:29 PM	Rate (0)
IBN-Service Posts: 8946 Rating: (1000)	cbcX Looking at Sydney's solution, I used FC 6 to convert the DT vars to DATE vars. But what function can subtract 2 DATE Vars? Do I need to convert them to (d)integers first? -D
IBN-Service Posts: 8946 Rating: (1000)
Suggestion To thank Quote Answer

7/9/2023 6:49 AM	Rate (0)
Parvez333 Member Joined: 2/16/2022 Last visit: 9/16/2025 Posts: 6 Rating: (0)	Hey cbcX Congratulations that u have achieved what you wanted. I also have same need. Please share your Function. Thanks in Advance

Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on