File store LD and MG which book by Today

  • kda
  • Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
11 years 6 months ago #12662 by kda
Dear all,

Please help me, I want to get file which store LD and MG which book by today. If we get from file LD and MG . It takes time to select it. Has it the concate file store them.

Thanks

Please Log in or Create an account to join the conversation.

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • TAFj-R20 - 'unix'
More
11 years 6 months ago #12663 by jpb
I can't say a word about MG.

But for LD you can select Fxxx.LMM.SCHEDULES with @ID LIKE "LD...YYYYddd..."
YYYY = year
ddd = julian day

Please Log in or Create an account to join the conversation.

  • kda
  • Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
11 years 6 months ago #12672 by kda
Hi jpb,
Could u guide me the above statement if we select by today how could we do for julian day.

Please Log in or Create an account to join the conversation.

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • TAFj-R20 - 'unix'
More
11 years 6 months ago #12675 by jpb
Today is September, 27th 2012, in the format above 2012271.

You can use the field JULIAN.DATE from DATES for today or

GRE.DATE = "20120927"
JUL.DATE = ""
CALL JULDATE(GRE.DATE,JUL.DATE)

will give you 2012271 in JUL.DATE as well.

Selection will be

SELECT Fxxx.LMM.SCHEDULES WITH @ID LIKE "LD...":JUL.DATE:"..."

If you like you can also define a separate field for the date in STANDARD.SELECTION (see field LD.ID) and use this for selecting.

Please Log in or Create an account to join the conversation.

  • kda
  • Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
11 years 6 months ago #12677 by kda
Yes thanks
we have contact file for MG?

Please Log in or Create an account to join the conversation.

Time to create page: 0.114 seconds