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?
You can combine values like CONCATENATE(DAY([Date]),MONTH([Date]),YEAR([Date]))
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 …
Have you tried to use TEXT exrpression TEXT([Date]) inside of your CONCATENATE?
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!