Convert a dynamic variable to a date format

[deekey2]

Hi All,

I'm trying to get a input field (vToday as below) and change it to dynamic variable(target to put to a dynamic table later)..

but somehow, the "29/10/2021" will convert to "0.00143.." as below

so I try to change the vToday to "44498", then the result is my expectation.

Can anyone help to find the solution, the expected input and output as below.

input :

output:

p.s. I have to get via dynamic var like $(vToday) so I can put to table for dynamic date range change, I tried to put vToday but the table hasn't updated :X

Thanks.

Dee

[Lisa_P]

If you want to keep the date in that format use vToday rather than $(vToday).

Using the $( ) tried to evaluate the contents so it divides 29 by 10 then by 2021 giving you 0.001434933....

[Vegar · Accepted solution]

If you need to dollar expand your variable then you could try to quote it to force your string to be handled as a string, like this: '$(vToday)'