Skip to Content (Press Enter)
2022-09-10 22-09-09
Francisco Brito
17Views
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
15 Oct 2020
Copy Link
2018-10-29 08-31-03
João Marques
 
MVP
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
15 Oct 2020
Copy Link
2022-09-10 22-09-09
Francisco Brito

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
15 Oct 2020
Copy Link
2018-10-29 08-31-03
João Marques
 
MVP

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
15 Oct 2020
Copy Link
2022-09-10 22-09-09
Francisco Brito

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
15 Oct 2020
Copy Link
2023-03-09 07-10-59
Vipasha Sharma

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
15 Oct 2020
Copy Link
2023-03-09 07-10-59
Vipasha Sharma

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
15 Oct 2020
Copy Link
2018-10-29 08-31-03
João Marques
 
MVP
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
15 Oct 2020
Copy Link
2022-09-10 22-09-09
Francisco Brito

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
15 Oct 2020
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.