Hello Community I use the ddmmyyyy date forma...

(Alfredo Pou) #1

Hello Community I use the ddmmyyyy date format, but when I concatenate a date type column into a text type virtual column, the date is shown mmddyyyy. I can not find an expression that converts date format. Can I make it look good?

(Aleksi Alkio) #2

You can combine values like CONCATENATE(DAY([Date]),MONTH([Date]),YEAR([Date]))

(Alfredo Pou) #3

I would have to decompose the whole date and time and then accommodate it. My question was if there is no expression to format the text. Thank you anyway. It’s not something so serious … I leave it like this …

(Aleksi Alkio) #4

Have you tried to use TEXT exrpression TEXT([Date]) inside of your CONCATENATE?

(Alfredo Pou) #5

Yes it worked! I was looking for a text expression, but I assumed it had to have a format argument. for example:

TEXT ([Date], “dd/mm/yy hh:mm”) Many thanks!