News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Error - Type conversio...

Microsoft Dynamics NAV (Archived)

Error - Type conversion is not possible

(0) Share

Report

Report

Posted on by jsshivalik

3,099

Hi

In the below like it is giving error "Type Conversion is not possible because one of the operands contain an Invalid Type"

Date:text

SETRANGE("Sales Shipment Header"."Order Date","Sales Invoice Header".GETFILTER("Sales Invoice Header"."Order Date"));

Thanks

*This post is locked for comments

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

Olister Rumao 3,959 on at

Like (0)

Report

RE: Error - Type conversion is not possible

Hi,

When your using the Record.GETFILTER, it gives you the filters applied to the records.

Use the following code

SETFILTER("Sales Shipment Header"."Order Date","Sales Invoice Header".GETFILTER("Sales Invoice Header"."Order Date"));
Community Member on at

Like (0)

Report

RE: Error - Type conversion is not possible

.
AlexDen 90 on at

Like (0)

Report

RE: Error - Type conversion is not possible

Hi.

Use SETFILTER instead of SETRANGE in this case.

Helpful resources

News and Announcements

Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Leaderboard > Microsoft Dynamics NAV (Archived)

#1

Sohail Ahmed 2

#1

mmv 2

#1

Amol Salvi 2

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans