:?: I've been trying to determine the week number of a date, and am now frustrated (well, a bit disappointed in my own capabilities ;) ) because I don't get any good results.
Ofcourse I can use Excel's function WEEKNUM but it must be possible to calculate it with JetReports based on the posting date from NAV. I just don't see how….
Hope someone can help me.
Willem
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Willem!
You could probably do it with the NAV Date table, something like this (assume the date is in cell C4):=NL(,"date","Period No.","Period Type","Week","Period Start",NP("DateFilter",C4-6,C4))
Does that work for you?
Regards,
Hughes
Please sign in to leave a comment.