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!
User | Count |
---|---|
42 | |
27 | |
25 | |
20 | |
13 |