Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

TIA Portal- Date to String?

Created by: Steve8676 at: 1/10/2014 11:35 PM (6 Replies)

Rating (2)

Thanks 4

7 Entries

1/10/2014 11:35 PM	Rate (0)
Steve8676 Posts: 18 Rating: (0)	How can i convert Date to String? I've used the T_CONV to convert the local time to a DATE. But i now want to convert the Date to String. So i can add this to another String. I.E "2014-01-01 FileName" Thanks Steve.
Steve8676 Posts: 18 Rating: (0)
Suggestion To thank Quote Answer

1/13/2014 5:29 PM	Rate (0)
Denilson Pegaia Platinum Expert Joined: 9/23/2005 Last visit: 1/27/2023 Posts: 4176 Rating: (1323)	Hi, it is relactivly difficult to build a conversion date to string, because each customer needs a different format for the date string. On other hand DTL is a struct of individual integer values (year, month, day, hour, minute, seconds, etc.). I suggest you build your own block for the conversion, conveting each field (year, month, day, hour, minute, seconds, etc.) individally and build, with concat instruction your own string standard.
	Denilson Pegaia Siemens Industry Sector Technical Support
Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users pro241036

2/4/2014 5:25 PM	Rate (0)
GrasserF Posts: 344 Rating: (6)	new question is splittet to TIA Portal, Date to String, over 300 and S7 teleservice sending text messages .
GrasserF Posts: 344 Rating: (6)
Suggestion To thank Quote Answer

6/22/2020 11:37 AM	Rate (1)
Bet1971 Member Joined: 9/2/2015 Last visit: 11/4/2022 Posts: 3 Rating: (1)	Here an Example how to convert Date to string (FC Block Not Optimized). Attachment FC_DateToString.pdf (2845 Downloads)

Suggestion To thank Quote Answer
This contribution was helpful to 3 thankful Users AutoGen_5254588 asdcxzasd Grantek-TCB

7/8/2021 12:26 PM	Rate (0)
StewPID Member Joined: 2/5/2019 Last visit: 10/11/2022 Posts: 1 Rating: (0)	Absolutely fantastic 👍

Suggestion To thank Quote Answer

7/8/2021 12:59 PM	Rate (0)
jacek d Platinum Expert Joined: 9/23/2005 Last visit: 1/27/2023 Posts: 4087 Rating: (630)	StewPID Absolutely fantastic 👍 I kindly disagree. Mix of non-optimized data, STL in S7-1500. And 1kB on the stack. Far from fantastic.
	Regards, Jacek What is confusing you is the fact that you never see a number but always its digit representation. So you end up thinking that the number is the representation. - Andrej Bauer Any claims against me - based on whatever legal reason - resulting from the use of any code and/or ideas presented on this forum shall be excluded. #StayWithUkraine
Suggestion To thank Quote Answer

4/23/2022 2:54 PM	Rate (1)
WojciechSulek Member Joined: 2/4/2021 Last visit: 6/6/2022 Posts: 2 Rating: (1)	Hi Lads, With small modifications you can have the string in any format you want. Look up the prinscreen and make SCL function block the same as mine. Of course you can make it more sexy and replace ' 1' with '01'. I needed my string to be passed to SQL so it did not matter. Source code to save you typing: #DTL := DT_TO_DTL(#DT); VAL_STRG(IN := #DTL.YEAR, SIZE := 4, PREC := 0, FORMAT := 16#0000, P := 1, OUT => #Year); VAL_STRG(IN := #DTL.MONTH, SIZE := 2, PREC := 0, FORMAT := 16#0000, P := 1, OUT => #Month); VAL_STRG(IN := #DTL.DAY, SIZE := 2, PREC := 0, FORMAT := 16#0000, P := 1, OUT => #Day); VAL_STRG(IN := #DTL.HOUR, SIZE := 2, PREC := 0, FORMAT := 16#0000, P := 1, OUT => #Hour); VAL_STRG(IN := #DTL.MINUTE, SIZE := 2, PREC := 0, FORMAT := 16#0000, P := 1, OUT => #Minute); VAL_STRG(IN := #DTL.SECOND, SIZE := 2, PREC := 0, FORMAT := 16#0000, P := 1, OUT => #Second); #String := CONCAT( IN1 := #Year, IN2 := '/', IN3 := #Month, IN4 := '/', IN5 := #Day, IN6 := ' ', IN7 := #Hour, IN8 := ':', IN9 := #Minute, IN10 := ':', IN11 := #Second); Attachment DT_TO_STRING.png (609 Downloads)

Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on