i want to retrieve record b/w 2 dates in as400

Answer Posted / vijay

Take date 1 and date 2 as date fields and give the condition as If date 1 > = date and date 2 < = date ;
dsply date ;
Endif; then u can retrieve the records based on the above condition.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Program to read marks of 10 students for 4 subjects and compute and display total marks and status of each student in rpg

712


what is the procedure and explain about real time scenario.

1471


How can we override a file during runtime in rpg?

677


can I touch the array during treatments?

750


What is file identifier where we can use?

635






How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?

1553


1.Load an runtime array of length 99 from the pf and you want to handle all the possible errors?

2360


thanks mr.Harshad R Suryawaunshi,i'm new to as400 i think you are telling in rpgile i know only rpg400 if possible can you tell in rpg400

1881


What is ment by record level identifier?

645


what is the use of sflnxtchg?

795


how do I declare a minor?

707


what is the difference between do while and do until?

693


Assume 2 users are using the same file and first user updates some record in the file. Will the 2nd user will be able to see the updated record or not?

503


are there any useful c runtime apis that I can call from rpg iv?

689


How to create a login screen using a command instead of display file.... intention is to get a password field on a command..... how do you achieve this...

1302