Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
mandilicious
Creator II
Creator II

How to format in expressions

Hi Champs

I need to format date in my expression to be like YYYY-MM-DD

i have below in my expression and in my table.

Below is where i need to make my changes

Name in exp.PNG

Below is the Merit date i need to Change to YYYY-MM-DD?

Date.PNG

Thank you in advance.

1 Solution

Accepted Solutions
OmarBenSalem
Partner
Partner

Just change ur date

from :

MeritDate

to :

Date(MertiDate,'YYYY-MM-DD')

or date(timestamp#(MertiDate,'YYYY-MM-DD hh:mm:ss.ffff'),'YYYY-MM-DD')

View solution in original post

6 Replies
OmarBenSalem
Partner
Partner

Just change ur date

from :

MeritDate

to :

Date(MertiDate,'YYYY-MM-DD')

or date(timestamp#(MertiDate,'YYYY-MM-DD hh:mm:ss.ffff'),'YYYY-MM-DD')

View solution in original post

prashantsanchet
Creator
Creator

Hi ,

you can use  following expression .

Date(Date#(subfield([Merit Date],' ',1),'YYYY-MM-DD'),'YYYY/MM/DD')


Change the format of date as per your data.


Regards,

Prashant

agigliotti
Partner
Partner

you can do it using the Floor function as below:

=date(Floor( date#([Merit Date], 'YYYY-MM-DD hh:mm:ss.ffff' ) ), 'YYYY-MM-DD' )


I hope it helps.

mandilicious
Creator II
Creator II
Author

Hi Omar

Thank you very much.

mandilicious
Creator II
Creator II
Author

Hi Prashant

Thank you very much for your help it works as well !

mandilicious
Creator II
Creator II
Author

Hi Andrea

Thank you very much for your help it works as well !