File store LD and MG which book by Today
- kda
- Topic Author
- Offline
- Platinum Member
Less
More
- Posts: 603
- Thank you received: 3
11 years 6 months ago #12662
by kda
File store LD and MG which book by Today was created 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 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
- Offline
- Moderator
- TAFj-R20 - 'unix'
Less
More
- Posts: 2854
- Thank you received: 649
11 years 6 months ago #12663
by jpb
Replied by jpb on topic File store LD and MG which book by Today
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
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
Less
More
- Posts: 603
- Thank you received: 3
11 years 6 months ago #12672
by kda
Replied by kda on topic File store LD and MG which book by Today
Hi jpb,
Could u guide me the above statement if we select by today how could we do for julian day.
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
- Offline
- Moderator
- TAFj-R20 - 'unix'
Less
More
- Posts: 2854
- Thank you received: 649
11 years 6 months ago #12675
by jpb
Replied by jpb on topic File store LD and MG which book by Today
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.
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
Less
More
- Posts: 603
- Thank you received: 3
11 years 6 months ago #12677
by kda
Replied by kda on topic File store LD and MG which book by Today
Yes thanks
we have contact file for MG?
we have contact file for MG?
Please Log in or Create an account to join the conversation.
Time to create page: 0.114 seconds