I am creating some dashboards for some queries in BI
For one of the queries there is a variable as Key date. I would like the
user to input the date value using the date picker form.
However, the date format in Visual composer is different from my BI format. In VC the date format is DD.MM.YYYY but the BI system expects the format MM/DD/YYYY in the variable.
I can write a formula to change the format but some of the european users have the format DD.MM.YYYY
Is there a way the system picks the format from user profile data.
Any help would be highly appreciated.