how to split getfilter into 2 dates

Answers

• Options

  lynge Member Posts: 85

  2020-01-17

  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-
  

  1
• Options

  navisionerin Member Posts: 161

  2020-01-17 Answer ✓

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

  0
• Options

  AlexDen Member Posts: 85

  2020-01-17

  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.

  2
• Options

  RockWithNAV Member Posts: 1,139

  2020-01-23

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

  Thanks
  
  Blog - rockwithnav.wordpress.com/
  Twitter - https://twitter.com/RockwithNav
  Facebook - https://facebook.com/rockwithnav/

  0