How to convert Timestamp to date

[Shahzad_Ahsan]

Hi

I have an issue with the date.

My date format in database is like this:

MyDate
2018-09-11T00:00:00.000+03:00
2018-09-12T00:00:00.000+03:00
2018-09-13T00:00:00.000+03:00

After using this expression   Date(Floor( Date(MyDate)),'DD/MM/YYYY')     I am getting this

MyDate
10/09/2018
11/09/2018
12/09/2018

I need the result like this

MyDate
11/09/2018
12/09/2018
13/09/2018

[bramkn · Accepted solution]

I guess CEIL() will be a quick and dirty fix.

[Shahzad_Ahsan]

Hi Bram

Thank You

I used this and worked fine

Date(Floor( Date(Ceil(MyDate))),'DD/MM/YYYY')

[bramkn]

Keep in mind that the dates you are using are now beeing strange with 3hours ahead or something like that which makes the Floor not work.

So when other dates appear in the dataset it might break.

would be better to fix the dates and use floor if this might happen.