7
Views
6
Comments
Solved
How i set the europe system in the date collum
Question

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


Rank: #64
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

Rank: #686

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 ;)

Rank: #64

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

Rank: #686

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

Rank: #659

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

Rank: #659

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")
Rank: #64
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

Rank: #686

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 ;)