How to calculate the difference between dates

[Mosufe]

I'm trying to calculate the difference between a date field and today. I've tried a lot of thing and none seems to work... Basicly what i need to do is:

Code: Select all

DateDiff(
  Today(),
  {vw_mtz_tk_solicitacao_servico_v3.data_solicitacao_servico},
  DateInterval.Day)
  

And the date field is a string, how can i cast it to date?

[Lech Kulikowski]

Hello,

Try to use:
{DateDiff(Today, DateTime.Parse(fw_mtz_tk_solicitacao_servico_v3.data_solicitacao_servico)).Days}

Thank you.

[Mosufe]

I'm getting this bizarre error now:



Someone have a documentation that explain how to create the calculated fields? I'm not finding it...

[Lech Kulikowski]

Hello,

Please clarify what product and version you use.

Thank you.

[Mosufe]

We use the Report JS version 2025.1.4

[Lech Kulikowski]

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.