Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date Array

Status
Not open for further replies.

BlurredVision

Technical User
Aug 6, 2001
326
GB
Can something like the following be done:

DateVar Range OpenClose := Date(DateTime({CHG_OPEN_CLOSE_DATE.OPEN_DATE})) to Date (DateTime({CHG_OPEN_CLOSE_DATE.CLOSE_DATE}));

DateVar array Holiday := [Date(2001,01,01), Date(2001,12,25)];

IF Holiday in OpenClose then true?


I know the above doesn't work.... Brian
 
It is too complex action for a software that deals with reporting.But it is not impossible I think :eek:). You may not perform this in SCR but you are sure to perform this by SQL.
But there is something important.Here as follows:
Your dates
DateVar array Holiday := [Date(2001,01,01), Date(2001,12,25)]...Where do they come from?From a parameter that users enter,completely static or else where?


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top