Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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
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