Francisco Brito
Rank: #686
7Views
6Comments
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


0
0
on 2020-10-15
Copy link to comment
João Marques
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

See solution in context
0
0
on 2020-10-15
Copy link to comment
Francisco Brito
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 ;)

0
0
on 2020-10-15
Copy link to comment
João Marques
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

0
0
on 2020-10-15
Copy link to comment
Francisco Brito
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

0
0
on 2020-10-15
Copy link to comment
Vipasha Sharma
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

0
0
on 2020-10-15
Copy link to comment
Vipasha Sharma
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")
0
0
on 2020-10-15
Copy link to comment
João Marques
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

0
0
on 2020-10-15
Copy link to comment
Francisco Brito
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 ;)

0
0
on 2020-10-15
Copy link to comment