AnsweredAssumed Answered

Script for date range

Question asked by bruns on Jul 16, 2014
Latest reply on Jul 16, 2014 by philmodjunk

Title

Script for date range

Post

     Hello, I currently have a date range script that works for finding info between two dates.  However I have added  a twist that I cannot figure out. Here is the sceniro, please let me know if I can provide more info.

      

     I have a table for vessel assignments and I have these fields:

     date_on_vessel

     date_off_vessel

     date of next crew change

     days on vessel (calc) (If (IsEmpty (date_off_vessel) ; Get (CurrentDate)  ; date_off_vessel) - date_on_vessel)

     g_datePickerStart

     g_datePickerEnd

     Currently if I use this I can find how long someone has been on the vessel realitive to date on and date off, however I have not been considering date of next crew change.

      

     I am trying to put together a Sea Service Report which includes all of the days on a vessel between to given dates, such as date on and date off but the new addition would also include date on until the current date ie the date the report ran.

      

     If I can provide more info please let me know.  I am including a script of what I currently have for showing crew changes between two dates.

      

Scan_Jul_9%2C_2014%2C_2_56_PM-page1.jpg

Outcomes