Slicing Time Dimension - Correct Format

[george55]

Hi all,

When want to use an expression to slice a date/timestamp can I do it always with this format: '13/02/2019' ? eg.:

Sum( {<Date = {">'13/02/2019'"} >} Field)

Or do I have to take a look how my data looks, eg.: '2019-02-13 13:50:44.676000', so do I have to change it to?:

Sum( {<Date = {">'2019-02-13'"} >} Field)

[nikitadeshwal · Accepted solution]

George,

After separating date from date-timestamp, if you convert it into this formate ( YYYY-MM-DD ) using Date#() function then Yes,  you can use it  Else you can use this ( DD.MM.YYYY ) formate only.

Thanks

[george55]

ok, then the variable DateFormat is the coreformat. With this format, you do not have to convert it to other formats. 

So, I close it and understood it 🙂

Thanks all