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

Huy Nguyen

Solved

Question

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!

13 May 2019

Pranav Pandey

Solution

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.

13 May 2019

Huy Nguyen

I have already resolved.

15 May 2019

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.