how to split getfilter into 2 dates

navisionerin

hi! I've got getfilter, which contains 2 dates from..to
I need to get the first and second as date fields
I tried everyhting but I couldn't work it out

navisionerin

Hi lynge, I tried
MinDate:= "G/L Account".GETRANGEMIN("Date Filter") but it's giving me 0D as a return value?

lynge

Hi navisionerin,

Please have a look at the GETRANGEMIN and GETRANGEMAX functions
https://docs.microsoft.com/en-us/dynamics-nav/getrangemin-function--record-
https://docs.microsoft.com/en-us/dynamics-nav/getrangemax-function--record-

navisionerin

Hi lynge, I tried
MinDate:= "G/L Account".GETRANGEMIN("Date Filter") but it's giving me 0D as a return value?

AlexDen

Hi,

Perhaps, you missed something.
Does this code show message with dates for you?

GLAccount.RESET;
GLAccount.SETRANGE("Date Filter", CALCDATE('<-CM>',TODAY),CALCDATE('<CM>',TODAY));
MESSAGE('Min: %1\Max: %2', GLAccount.GETRANGEMIN("Date Filter"),GLAccount.GETRANGEMAX("Date Filter"));

If yes then you have mistake in your code and filter on "Date Filter" is not applied.

RockWithNAV

@navisionerin - GETRANGEMAX and GETRANGEMIN is the easiest way to handle your case otherwise you have no other option other then TRIM.