Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

Help With Date Format Please

Created by: David_Suarez at: 12/18/2007 10:31 AM (4 Replies)

Rating (0)

Thanks 0

5 Entries

12/18/2007 10:31 AM	Rate (0)
David_Suarez Posts: 10 Rating: (0)	Hi, In VBS I've a Date Expression Like 18/12/2007 20:35:00, and to make a valid String to do a petition to SQL i need a expresion Like 2007-12-18 20:35:00, how can I transform it? Thanks
David_Suarez Posts: 10 Rating: (0)
Suggestion To thank Quote Answer

12/18/2007 12:11 PM	Rate (0)
Fatso Bronze Member Joined: 9/11/2006 Last visit: 3/17/2022 Posts: 168 Rating: (6)	Try Opening Wincc explorer>Computer name>Propertis>parameters Under Cental Time and Date Formatting select ISO8601

Suggestion To thank Quote Answer

12/18/2007 4:16 PM	Rate (0)
David_Suarez Posts: 10 Rating: (0)	But this only change the data format in, for example, TlgOnlineTable. But in my VBS Variable making with DateAdd it doesn´t change.
David_Suarez Posts: 10 Rating: (0)
Suggestion To thank Quote Answer

12/19/2007 12:00 PM	Rate (0)
Fatso Bronze Member Joined: 9/11/2006 Last visit: 3/17/2022 Posts: 168 Rating: (6)	If that is the case then try changing the date format in regional settings for your computer:Control Panel>Regional and Language Options>Regional Options>Customize>Date>Seperator

Suggestion To thank Quote Answer

12/21/2007 12:25 PM	Rate (0)
David_Suarez Posts: 10 Rating: (0)	Hi. I solve the problem with this. Thank you very much
David_Suarez Posts: 10 Rating: (0)
Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on