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

Nareshwar Raju Vane... 5,596 on at

Like (0)

Report

Hi Pete,

The screenshot hasn't been attached properly. Please reattach :)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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
Suggested answer

Nareshwar Raju Vane... 5,596 on at

Like (0)

Report

Hi,

Is this report multilingual?

Was this reply helpful? Yes No
Verified answer

Nareshwar Raju Vane... 5,596 on at

Like (0)

Report

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
Community Member on at

Like (0)

Report

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
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

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

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 50,243 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Gretchen 5 on at

Like (0)

Report

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
rnbergren 7 on at

Like (0)

Report

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

Days, Weeks, Minutes?

Was this reply helpful? Yes No