Date Comparison in xlate

[Scott Smith]

I need to check the expiration of insurance.  All I need is compare the value (if not null) with today’s date.  I am not able to get a clear picture of what this would look like.  Can I just compare the value against @now?

Topic

[Max Drown (Infor)]

I normally use tcl clock scan for that sort of thing.

-- Max Drown (Infor)

[Robert Kersemakers]

Yes: use ‘clock scan’ to turn the current date (‘clock seconds’) and your value into integers ie. seconds. Then subtract these integers to have the difference in seconds.

Zuyderland Medisch Centrum; Heerlen/Sittard; The Netherlands

[Russ Ross]

There are some tangible examples of getting time differences to determine desired action at this URL:

<a href="https://usspvlclovertch2.infor.com/viewtopic.php?t=2828&&#8221; class=”bbcode_url”>https://usspvlclovertch2.infor.com/viewtopic.php?t=2828&amp;

Russ Ross
RussRoss318@gmail.com

[Dennis Pfeifer]

I’m a simple guy.

I use the date in the MSH segment, taking the eight left most characters and store into a variable (MSH has current date). I then take the eight left most characters from the IN1 segment, and store in a variable. Next, an IF statement is used to compare the two ‘integers’

[Author]

Replies