How i set the europe system in the date collum

Hello guys, i have this datatable and i need in the collum "Data" (equal to Date) haved the system of europe date

what have: 2020/10/15

what i need: 15/10/2020


Hi Francisco,


You should use the function FormatDateTime, like on the image below:


Just replace the Date in my expression by your date field from the query and it should be fine.


Cheers,

João

João Marques wrote:

Hi Francisco,


You should use the function FormatDateTime, like on the image below:


Just replace the Date in my expression by your date field from the query and it should be fine.


Cheers,

João

 

 


It´s giving me error "Default value" must be set to a "Date" literal value

Hi Francisco,

FormatDateTime() is a built in function you will find it in format folder of build in function.

The variable that you are using that should be of type "date"

Regards,

Vipasha

If you "data" variable is of type text and if you cannot change its type to date then use as mention below

FormatDateTime(TextToDate(data),"dd/mm/yyyy")
Solution

Hi Francisco,


You don't need a local variable Date.

You click on the expression where you have the date you want to change, and then double click where it says Value (my example below):


This will open the expression with a value:

And then you change to this:



In my case, it is UserTable.List.User.Creation_Date, you replace by what is in your expression already.

Hope it helps.


Cheers,

João

Solution

João Marques wrote:

Hi Francisco,


You don't need a local variable Date.

You click on the expression where you have the date you want to change, and then double click where it says Value (my example below):


This will open the expression with a value:

And then you change to this:



In my case, it is UserTable.List.User.Creation_Date, you replace by what is in your expression already.

Hope it helps.


Cheers,

João

 

 Thanks man! It´s working you are the best ;)