Hi
Try below
If it is valid date then
1)for 02/01/11
Date('2-jan-11','DD/MM/YY')
or
2) for 02/01/2011
Date('2-jan-11', 'DD/MM/YYYY')
If it is not valid date then
1)for 02/01/11
Date(Date#('2-jan-11', 'DD-MMM-YY'), 'DD/MM/YY')
or
2) for 02/01/2011
Date(Date#('2-jan-11', 'DD-MMM-YY'), 'DD/MM/YYYY')
Regards
Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
