FlowFilter column, need to insert date period

Dynamics 365 Business Central/NAV Developers Forum
1

Hi all,

Can anybody know , how to insert date period into column (Data Type Date) in the NAV Table???

Thanx alt !!!

2

I mean from the Code [:D]

3

Can you be more clear please?

When do you need this?

4

Are you asking about how to create a date flowfilter field in a table, or how to add that field to a form/page? Looks like you’re in NAV 2013? Are you trying to do this in a Page or Form? Since you said something about doing it from code, maybe you want help setting the filter value in a date flowfilter? To set a filter using a flowfilter field, use the same syntax as you would for any other field. So, for example, if you wanted to set the filter for this year, you might enter the command: rec.setfilter('Date Flowfilter", ‘%1…%2’, 01012013D, 12312013D). You would replace “Date Flowfilter” with the name of your specific field.

If that doesn’t answer your question, maybe offer a bit more detail about what you’re trying to do?

5

Hi all,

Sorry for da delay,

Yeah it works Thnx alot George :slight_smile: :slight_smile: :slight_smile: !!!

Thank you all [:D]