showing date and saving datetime

Back to Forums

Diogo Barbosa

Solved

Question

Reactive

Application Type

Reactive

Hi!

I wanted to show my date fields as only date: dd-MM-yyyy, but in the batabase (external) it is represented as datetime, so when I save the values it must be datetime.

Is there any way to deal with this?

Thanks...

07 Oct 2022

Daniël Kuhlmann

MVP

Solution

Replying to Diogo Barbosa's comment on 07 Oct 2022 14:20:49

You now have the aggregate attribute directly in an expression.

Something like

Aggregate Name.List.Current.EntityName.AtrributeName

Change those to

FormattedDate(Aggregate Name.List.Current.EntityName.AtrributeName)

See solution in context

07 Oct 2022

Daniël Kuhlmann

MVP

Hi Diogo,

You can use the built-in function FormatDateTime to do that.

https://success.outsystems.com/Documentation/11/Reference/OutSystems_Language/Logic/Built-in_Functions/Format#FormatDateTime

Best practise is to create your own public action that calls FormatDateTime, so that you have the format only defined on one place. Changing the format, if you want to in the future, is then limited to one action to be changed.

Regards,

Daniel

07 Oct 2022

4 replies

Last reply 07 Oct 2022

Show thread

Hide thread

Diogo Barbosa

Thanks,

I understand the idea, but how can that be done with that action?

I must make some assignment, I think... but I'm not seeing what to assign to apply it to all the dates... I'm missing something :)

07 Oct 2022

Daniël Kuhlmann

MVP

Replying to Diogo Barbosa's comment on 07 Oct 2022 09:49:26

Create a client action FormattedDate
Input parameter called InputDateTime of datatype DateTime
Output parameter of datatype Text called FormattedDate
Use the the Assign widget
In the assign widget assign FormatDateTime(InputDateTime, "dd-MM-yyyy") to FormattedDate
Set the property IsFunction to True.
Now on every place where you still have the DateTime attribute directlty displayed from an aggregate, put it inside FormattedDate()

07 Oct 2022

Diogo Barbosa

Replying to Daniël Kuhlmann's comment on 07 Oct 2022 10:14:57

That looks great! :))

I just didn't understand the point 7... how to apply the function to the fields?

07 Oct 2022

Daniël Kuhlmann

MVP

Solution

Replying to Diogo Barbosa's comment on 07 Oct 2022 14:20:49

You now have the aggregate attribute directly in an expression.

Something like

Aggregate Name.List.Current.EntityName.AtrributeName

Change those to

FormattedDate(Aggregate Name.List.Current.EntityName.AtrributeName)

07 Oct 2022

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

See the full guidelines