The date formula should include a time unit

(0) Share

Report

Posted on by Community Member

Hello,

I am trying to run a customer statement like I normally do every month. When I try to run the report, I get the following error message:

Does anyone know what this means? Is there a fix for this?

Thanks for your help,

Pete

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (1)

Suggested answer

Gaurav0156 5 on at

Like (0)

Report

RE: The date formula should include a time unit

In 2023 with BC21 I faced the same error. Basically, the code has dataformula used as 'CM' which should be <CM>

So, brackets were needed, and it got resolved.

Thank you - Gaurav Singh

Was this reply helpful? Yes No
rnbergren 7 on at

Like (0)

Report

RE: The date formula should include a time unit

so what does D and WD and M and Q actually stand for?

Days, Weeks, Minutes?

Was this reply helpful? Yes No
Gretchen 5 on at

Like (0)

Report

RE: The date formula should include a time unit

I'm getting the same error message when trying trying to set up column layout to run a R12M (rolling 12 months) income statement. I'm using NAV 2009.

"The date formula 'FY[1] should include a time unit. Time units can be D, WD, WQ, M, Q, or Y. C, meaning current time unit based on date, can be specified as a prefix to the time unit." I'm putting my date FY[1] in the Comparison Period Formula field. For some reason, this version of NAV doesn't have the Comparison Date Formula field.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 49,097 Super User 2025 Season 2 on at

Like (0)

Report

RE: The date formula should include a time unit

can you run a debugger, and send the screenshot of it where it catches the error

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: The date formula should include a time unit

It looks like the value is indeed 30D. However, this is a swiss company that is trying to run this report. I am not sure if this makes a difference (language difference)?

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 49,097 Super User 2025 Season 2 on at

Like (0)

Report

RE: The date formula should include a time unit

When you are running the report what is the value you are using on Length of Aging Periods on the request page of the report ? Looks like it has value of 30T change that to 30D

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: The date formula should include a time unit

Thanks for the reply. Do you know where I have to make this change? Do I do this on the customer card?

Was this reply helpful? Yes No
Verified answer

Nareshwar Raju Vane... 5,596 on at

Like (0)

Report

RE: The date formula should include a time unit

Hi,

If it is in another language, please try to write in English, so the conflicts will be resolved.

Example: CALCDATE(‘+12M-1T’,BeginnGeschäftsjahr) becomes CALCDATE(‘<+12M-1D>’,BeginnGeschäftsjahr).

Check the link: noisyvan.wordpress.com/.../avoid-not-a-valid-time-unit-errors-with-multilanguage-calcdates

Was this reply helpful? Yes No
Suggested answer

Nareshwar Raju Vane... 5,596 on at

Like (0)

Report

RE: The date formula should include a time unit

Hi,

Is this report multilingual?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: The date formula should include a time unit

Error Message:

The date formula '-(30T) should include a time unit.

Time units can be: D,WD,W,M,Q or Y.

C, meaning current time unit based on date, can be specified as a prefix to the time unit.

Was this reply helpful? Yes No