Session Based on Open Closed Times

[BroSnarr]

Hello Everyone

I am working on a program for a Local Members only Night Club.. That can be open at any time of any day ..
set up as follows
I Have a main file that gets a entry price based on "TheDayOfWeek"
TheDayOfWeek = Monday |Price= 30
TheDayOfWeek = Tuesday|Price= 10
"" , ""
and is based on "OpenTime" and "Closed Time" so I used a Timestamp to relate from the main file to the Price File.. as so..
Main File ..
relationship = Mainfile "SessionDate" ≥ TimestampOpen and
relationship = Mainfile "SessionDate" ≤ TimestampClose
result = Price for Date Today or For Date one day before
if "TimeClosed" is after Midnight the next Day

The Problem I am getting is when the Club stays open after the Closing time... it will not show a price because the Get(CurrentTimeStamp) is out of range of the relationship.. I need to allow the Price for the OpenDate Price to continue to be used...

[Wim Decorte]

Automatic message

This topic has been moved from "Articles, Tips, Techniques & Solutions" to "Relationships".