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

date and time

Created by: kamel.bou at: 5/4/2012 5:35 PM (9 Replies)

Rating (0)

Thanks 1

10 Entries

5/4/2012 5:35 PM	Rate (0)
kamel.bou Posts: 12 Rating: (0)	hello I can't read a system date and time with wincc flexible and i went use it as nam of an excel file please if any one have an idea help me think's
kamel.bou Posts: 12 Rating: (0)
Suggestion To thank Quote Answer

5/4/2012 7:46 PM	Rate (0)
tyro Posts: 9 Rating: (0)	Hi, I havent used WinCC Flex in a long time but as I remember you can use today() function in VB script to get system command. Give it a try and let me know.
tyro Posts: 9 Rating: (0)
Suggestion To thank Quote Answer

5/5/2012 12:27 PM	Rate (0)
fbelic Posts: 327 Rating: (28)	Greetings This is a script I use to get date and time in ISO format for naming files: Dim broj, iso iso = CStr(DatePart("yyyy", Now)) broj = CInt(DatePart("m", Now)) If(broj<10) Then iso = iso & "0" & CStr(DatePart("m", Now)) Else iso = iso & CStr(DatePart("m", Now)) End If broj = CInt(DatePart("d", Now)) If(broj<10) Then iso = iso & "0" & CStr(DatePart("d", Now)) Else iso = iso & CStr(DatePart("d", Now)) End If If(bezVremena <> True) Then iso = iso & "T" broj = CInt(DatePart("h", Now)) If(broj<10) Then iso = iso & "0" & CStr(DatePart("h", Now)) Else iso = iso & CStr(DatePart("h", Now)) End If broj = CInt(DatePart("n", Now)) If(broj<10) Then iso = iso & "0" & CStr(DatePart("n", Now)) Else iso = iso & CStr(DatePart("n", Now)) End If broj = CInt(DatePart("s", Now)) If(broj<10) Then iso = iso & "0" & CStr(DatePart("s", Now)) Else iso = iso & CStr(DatePart("s", Now)) End If End If VratiDatumVrijemeISO = iso Make a new script, set its type as function and add a new parameter called "bezVremena" (it is a bool variable that says to you want time or just date; false is both date and time, true is only date). Best regards
fbelic Posts: 327 Rating: (28)
Suggestion To thank Quote Answer

5/5/2012 12:29 PM	Rate (0)
fbelic Posts: 327 Rating: (28)	Greetings I forgot to write that function should be called "VratiDatumVrijemeISO". Best regards
fbelic Posts: 327 Rating: (28)
Suggestion To thank Quote Answer

5/5/2012 12:35 PM	Rate (0)
Darius Platinum Expert Joined: 9/28/2005 Last visit: 7/24/2025 Posts: 2957 Rating: (243)	Hi, For WinCC Flexible you need to use Now function. Here is from help system: Dim MyVar MyVar = Now ' MyVar contains the current date and time.
	Best regards, Darius
Suggestion To thank Quote Answer

5/5/2012 2:39 PM	Rate (0)
Anit Kumar Posts: 153 Rating: (2)	if you want script in vb then you use attached code to creat excel file named as date or time Attachment CODE FOR CREATING EXCEL IN WINCC.zip (755 Downloads)
Anit Kumar Posts: 153 Rating: (2)
Suggestion To thank Quote Answer

5/5/2012 2:49 PM	Rate (0)
Ayman Elotaify Platinum Member Joined: 5/28/2008 Last visit: 9/3/2025 Posts: 4522 Rating: (843)	Hello, Did you read this FAQ: How do you synchronize the date and time between an operator panel and an S7-300/S7-400 controller with WinCC flexible? Hope this helps.
	Ayman Elotaify
Suggestion To thank Quote Answer

5/7/2012 6:11 AM	Rate (0)
viralpatel Silver Member Joined: 11/18/2010 Last visit: 8/5/2022 Posts: 523 Rating: (32)	kamel.bou hello I can't read a system date and time with wincc flexible and i went use it as nam of an excel file please if any one have an idea help me think's use now() function in wincc flexi for getting system dateand to use this date as file name must sure that you date format is like 07.05.2012 or 07_05_2012 it is set in control panel 07/05/2012 defult is not working. regards, viral

Suggestion To thank Quote Answer

5/7/2012 6:13 PM	Rate (0)
kamel.bou Posts: 12 Rating: (0)	think you for all i just do this : Dim date_local,jour,mois,année jour = Day (Now) mois = Month (Now) année= Year (Now) SetValue date_local ,jour &"-"& mois &"-"& année Set wsh = CreateObject("WScript.Shell") TheTargetBookName = date_local&".xls" TheTargetBook = "C:\Out\" & TheTargetBookName
kamel.bou Posts: 12 Rating: (0)
Suggestion To thank Quote Answer

5/7/2012 6:29 PM	Rate (0)
fbelic Posts: 327 Rating: (28)	Greetings Yes, that will work. But it is convinient to make it year-month-day, since in that way it will be sorted by years, months and days. Of course, depending on your PC settings, you will miss the leading zeros, therefore I made that big script. Best regards
fbelic Posts: 327 Rating: (28)
Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users TEJA KULKARNI

|

Share this page:

Share this page on...

Follow us on