Year Filter

Business Central/NAV Developers Forum
1

Hi all I have a blackout and need some Help I need to set a Filter from 0101 … 3112 (January till December) The year i will get from a Date field. For Example: In my Date field i have the Value 26.05.04 Now i must set the Filter 01.01.04…31.12.04 IF The Value would be 26.05.02 the Filter must be 01.01.02…31.12.02 Anybody can help?

2

Use the function DATETODMY to cathch the year. Define to variable Start Date and Finish date And use the year retrieving by the function DATETODMY

3

Or use WorkDate… (The client itself provides this variable under “Arbeitsdatum” if you are using the swiss client)

4

SETRANGE(fooField, CALCDATE('<-CY>', dateVar), CALCDATE('<CY>', dateVar)); <-CY>/ can be replaced by -LJ/LJ in the German/Swiss version.

5

Thanks a lot for your answers