Issue with LEFT

[Asiolinka]

Hi, 

I have an issue with LEFT. Trying to use it to obtain part of date from format like: 2022-05-03 00:000:0000 - I need only first 10 characters. 

Qlik can't see any records. Original data type:  #numeric #integer

Tried also: Date, Date#, Num, Text, Text Trim, 

what's more: I can do it from visualisation part.. Could you please assist me? Any ideas how can I obtain only date?

[Rams- · Accepted solution]

Hi,

if you want to use Left function then use this expression:

date(left ('2022-05-03 00:000:0000',10),'YYYY/MM/DD')

Output:

Or you can use below function in backend:

Date(floor("Date"),'DD/MM/YYYY') , "Date" is your date field

Hope this helps,

help user find answers ! don't forget to mark  a solution that work for you and click the like button!

[Asiolinka]

Second function works!

Thx a lot!

[Prem0212]

Date('2022-05-03 00:000:0000','YYYY-MM-DD')     this function will  also work  for you.

Please like and accept the solution if u liked it