Compare two date/times in a grid

[lgrupido]

I have a grid with a begin_datetime and end_datetime.

I want to show an error in-line in the grid when the end_datetime is less than the begin_datetime.

In this case, I am not trying to stop the system from saving or anything, I just want a piece of text to show when that happens.

So I have a piece of text in the grid and in the show/hide expression of the text I have:

End_Datetime > '' and Begin_Datetime > End_Datetime

That works great for the date portion, but not for the time.

ie:

Begin_Datetime = 04/10/2018 10:00
End_Datetime = 04/10/2018 09:00

These values do not cause the text to show and I want them to.

How do I get it to recognize the time portion?

[lvasic]

Re: Compare two date/times in a grid

if you convert the date time to a number. You can then compare the numbers.
d1.valueOf() > d2.valueOf();

[Jay Talbott]

Re: Compare two date/times in a grid

Larry,
If you do something like this in the interactive window, you can see that "begin" is not less than "end"

Begin_Datetime = "04/10/2018 10:00"

End_Datetime = "04/10/2018 09:00"

begin = ctod(word(begin_datetime,1))+ctot(word(begin_datetime,2))

end = ctod(word(end_datetime,1))+ctot(word(end_datetime,2))
?begin
= 04/10/2018 10:00:00 00 am

?end
= 04/10/2018 09:00:00 00 am


?begin< end
= .F.


= .F.

You can use that in the Xbasic validation or in an onBlur event to do an ajax callback and show an alert.

[Davidk]

Re: Compare two date/times in a grid

I have a grid with a begin_datetime and end_datetime...

Is this a process you want during grid data entry, grid data render, or both?

[Davidk]

Re: Compare two date/times in a grid

If you want to do this client-side... you'll need to convert your fields from date strings to date objects. Once they are date objects, you can compare them.

var bd = new Date();
var ed = new Date();
bd.fromFormat({grid.Object}.getValue('G','BEGIN_DATETIME',{Grid.RowNumber}),"MM-dd-yyyy 0h:0m:0s");
ed.fromFormat({grid.Object}.getValue('G','END_DATETIME',{Grid.RowNumber}),"MM-dd-yyyy 0h:0m:0s");
var diff = ed - bd;

This is running off a button in the Grid part. If running from somewhere else, {Grid.RowNumber} may not be appropriate... so you may need

var rowNum = {Grid.Object}._selectedRow;

or

var rowNum={grid.Object}.getSelectedRow();

[lvasic]

Re: Compare two date/times in a grid

I think this is what you're looking for. All client side. https://www.screencast.com/t/asQqIYBjqTx

[lgrupido]

Re: Compare two date/times in a grid

Thank you all for your support!

I am going with Lee's method as it is closest to what I was trying to do.

As a bit of background, the data already has some bad values in it, but I can't stop the system from working on every record that is messed up. So I want to show the error message, but not force a fix.

It's not an emergency and it doesn't always matter.