How to format in expressions

[mandilicious]

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

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

Thank you in advance.

[OmarBenSalem · Accepted solution]

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')

[prashantsanchet]

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]

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]

Hi Omar

Thank you very much.

[mandilicious]

Hi Prashant

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

[mandilicious]

Hi Andrea

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