Convert date parameter to a date

Question & Answer
1

Hello,

I set up a parameter with the date that I am using as a parameter. Unfortunately, it’s shown as a string. An example below:

image

How can I convert it to a date in the following format: ‘YYYY-MM-DD’.

UPDATE:

Tried the DEAFULT_DATE function but apparently, it is unable to decode the string above and picks a default value.

2

Hi,

You need to check what’s the data type in your dataset.
After that you can format it as you want.

image

regards,
Naveed Ali

3

In the dataset, it’s a date. You referred here to changing the datatype on the analysis, not the dataset.

4

If it’s a date in the dataset then it’s being transformed in the analysis and needs to get changed in the analysis.

Is this a kpi you are showing us?

Can you show me the field wells?

5

I showed you the result of narrative. Actually a parameter which is based on the date.

6

Can you try and wrap it in an epoch date?