Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] Convert date to string use tConvertType

I have this structure
tDatabase-tConvertType
I take the schema and if i modified the schema of tConvertType for example
database          convertType
id int               id change to String
date date        date date
all is correct
but if i try
id int          id int
date date   date try to change to string
I have error how i can convert string to date?
Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

I tried in same way as you mentioned it's working fine 
tconverttype component schema 
Checkout attached screenschots
0683p000009MEdU.png
0683p000009MEcp.png

View solution in original post

2 Replies
Anonymous
Not applicable
Author

I do not know why but in a scenario like this Date->String the auto cast function does not return a value. But if you use explicit cast it works well. The Date will be converted into a string using the Date pattern from the input schema.
Anonymous
Not applicable
Author

I tried in same way as you mentioned it's working fine 
tconverttype component schema 
Checkout attached screenschots
0683p000009MEdU.png
0683p000009MEcp.png