use TEXT() to change the format from an EnumList column type (base : Date)

[Ruxandra]

Hello!

I have in Table1 a column type EnumList and base "Date", where I display some date using SELECT(Table2[dates],IN([idUniqueTable2],[_THISROW].[idTable1])) in Valid_If. 

On my pdf file which is sent using an Automation, these dates are not displayed, I don't know why, so I created a virtual column and I want to use Text() in order to change the format from English to European (dd.MM.yyyy), but it is not working, I think because the column I want to change is EnumList.

How should I use TEXT() to change the format of every element of my dates list?  

Thank you for your help!

Regards!

Ruxandra

[WillowMobileSys · Accepted solution]

---

@Ruxandra wrote:

On my pdf file which is sent using an Automation, these dates are not displayed,

---

I assume by "not displayed" you mean the dates are not displayed int he expected format??  

Confirm that your template file (and Google itself) is configured to use the correct locale/Language setting.  See image below.  (It has been a while since I have needed to deal with dates in a European format so I hope I am remembering correctly).  



You should not need to perform any special formatting of dates.

I hope this helps!

[Ruxandra]

Hello! 

You are right, it depends on the regional settings. I use English settings; I think final user should use European settings.

Thank you!

Regards!

[Ruxandra]

Hello! 

For information, finally it displayed the format I needed on the pdf file, but only after changing the "Localisation" of the table settings, as found in a forum topic. Changing the format on the docs file shows the date in the view form, but not on the pdf file.

Thank you!

[Joseph_Seddik]

Would you please show the all the column types in both your table?

[Ruxandra]

Thank you, Joseph, for your kindness, I have my regional Settings in English, final users should see in European format.

But, I would like to ask if there is any possibility to use TEXT() function on a EnumList column based on Date? I have a column where I select some IDs and, depending on these IDs, in other column I select the dates , (the column is type "EnumList").

Thank you for your advice!

Regards!

Ruxandra  

[Joseph_Seddik]

Without doing anything, final users will see the format according to the Regional Settings/Local of their devices. This applies to date, time, and price columns. Different users can see different formats for the same view. 

If you want to use TEXT() to force a display format and use it in a list, then before constructing the list, you should have a separate text column where you make this format for each row, then make the list out of this column. 

[Ruxandra]

Hello, Joseph!

For information, finally it displayed the format I needed on the pdf file, but only after changing the "Localisation" of the table settings, as found in a forum topic. I think, changing the format on the docs file shows the date in the view form, but not on the .pdf file. I have made many tests, I changed the format in docs file, in browser (Edge) as I read in appsheet doc, and also my computer regional settings, but this change didn't affect the pdf file. Finally, by changing the Localisation  in my table settings, the date had the format I need on my pdf file. 

Thank you!