I am trying to compare two dates and then choose the lower of the two dates in a BPM. One date is in a UD table and one is entered by a user, so will be in BPMData.Date03. I have tried putting this in a Condition and a Set Argument/Variable, but nothing seems to work for me. When I try to do it s…

I don’t think it should be as hard as you are making it. I think you might have something more simple set up wrong. Can you show some screen shots of your BPM?

Converting a date to a decimal is not going to work. I would recommend get some basics in before you tackle any of this if you admittedly don’t know C# lots of resources online here is one to get you started if you want to spend some money Team Treehouse is awesome!

Also, your help files, or Epic Web has the tools guide which will introduce you to some BPM’s. I would spend some time with that. [image]

[image] [image] [image] [image] Thanks Brandon. The first image is just of my whole workflow. The next three are of the area I am having the problem.

Thanks Joshua. I will check that out.

Can I ask why you are converting the dates to integers/decimals?

Only because it didn’t seem to work to just use the dates as they were, so was trying different things. I definitely don’t need to do that.

What does it do when you try the just the dates themselves?

I am able to save within the design view, but when I get back out to the Method Directives screen and hit save, I get the “error BPM006: Result of expression cannot be assigned to variable of ‘System.DateTime?’ type” error.

did you use the check syntax button on the expression editor?

Compare Dates in BPM

Epicor ERP 10

josecgomez (Jose C Gomez) January 21, 2019, 9:52pm 14

The issue is that one of your date is a nullable and can’t be compared to a non nullable date. Look up

Topic		Replies	Views
BPM help Epicor ERP 10 bpm	18	3016	February 21, 2019
BPM C# Comparing Dates Epicor ERP 10 bpm , c	8	2293	August 23, 2020
BPM Method Directive Incompatible Data Type Error Epicor ERP 10 e10 , bpm , customization	9	1540	February 9, 2021
BPM Expression for INT DateTime? Epicor ERP 10	2	1221	April 28, 2017
Epicor Date data type in C# Epicor ERP 10	8	6263	September 5, 2017

Compare Dates in BPM

Related topics