How to group by date only in DateTime data type column in outsystem?

I want to group by date (Y-m-d) ony in DateTime(Y-m-d H:i:s) column in Aggregate but don't know how to do it.

I can use function group by date(CreatedDate) in MySQL to solve this task.

 Any help is appreciated.  Thanks!


Hi Huy Nguyen,

I think this might help you.

 Add a new column in the aggregate and give it a proper name. Add the following expression to create the value

SyntaxEditor Code Snippet

DateTimeToDate([Entity].[Your DateTime Column])

 In table record add a new column and expression to display the new column value. To sorting function pass

"[New Column Name]".

Please see the screen shot.


Hi Pranav Pandey,

I have already resolved.