Reports

Business Central/NAV Developers Forum
1

in Reports

I have Doubt about Date .i.e when i give Date Return Should Be a Month Name Only . Will U try this ’

and ONe More is

How to Use GetMin,GetMax Functions In Date Filter

.Plz Slove These Problems

2

You can use the Format function to display your date however you want, including just displaying the month name. Lookup the functions in the development documentation or the NAV C/SIDE Help Menu if you are confused about how to use them. There are examples for everything.

3

DATE2DMY Function (DATE)

Returns the day, month, or year of a Date Data Type.

d := TODAY;
day := DATE2DMY(d,1);
month := DATE2DMY(d,2);
year := DATE2DMY(d,3);

Use GETRANGEMIN(“Posting Date”)

GETRANGEMAX(“Posting Date”)

For min and max dates

4

i want Show Dates should Be In Get Max Date And Get Min Date

5

GETRANGEMIN(“Posting Date”)

GETRANGEMAX(“Posting Date”)

these will do the same…