Format Date change between QlikView/Qliksense

[ALEX1977ALEX]

Hello community,

i have an issue on a format date between QlikView et QlikSense

This expression is considered like an number on Qlikview

MYdate=02/01/2019 00:00:00

year(MYdate)&num(month(MYdate),00)as MYdate

But on qliksense it's considered like a string.

so i can't reuse my  code because it's not the same format

How can i format this Date into 201901 numeric format

Thank so lot

[ALEX1977ALEX]

my issue is about use a trigger select a value in a field

the trigger on Qlikview is ok

The trigger on QLiksense is KO

[ALEX1977ALEX]

='("202110"|"202111"|"202112")'

no selection at all on my field

Do not undersand

[brunobertels]

Hi 

Seems like Mydate looks like a timestamp but not recognise as a timestamp 

so first let's transform it to a timestamp :

timestamp#(Mydate,'DD/MM/YYYY hh:mm:ss')

then floor it as a date : 

Date(floor(Timestamp#(Mydate, 'DD/MM/YYYY hh:mm:ss') ),'DD/MM/YYYY')

So regarding your mesure it will look like : 

year(

Date(floor(Timestamp#(Mydate, 'DD/MM/YYYY hh:mm:ss') ),'DD/MM/YYYY')

)

&

num(month(

Date(floor(Timestamp#(Mydate, 'DD/MM/YYYY hh:mm:ss') ),'DD/MM/YYYY')

),00)

[ALEX1977ALEX]

i had to modify the type of the trigger

select value on a fields =>KO

Select value matches search =OK

DO NOT UNDERSTAND

[ALEX1977ALEX]

hello Bruno

My issue was raised , i only change the type of the trigger on an action...

SO my title issue was not  good.

Thank for your return