Search results

  1. G

    Help required

    Relatively new to the forum, but need the benefit of some experience in a problem I cannot resolve. Simply - I have 3 pre-determined data sources which append to 3 different tables. Table 1 - Shipment Number Table 2 - Shipment Number - Delivery Number Table 3 -Delivery...
  2. G

    Week Number from Date for Fiscal Year

    Hi Everyone - newbie poster Could you support with the following please- I have a list of dates dd:mm:yyyy for transactions which I need to allocate a week number to. Criteria is the Fiscal year starts on the 1st September each year. Thus 1/9 is always Week 1 Many thanks Garmani
  3. G

    DateDiff in hours in excess of 24 - how to show as decimel value

    I have a DateDiff formula for elapsed time between two date/time fields extending over24 hours. Elapsed Time: Abs(DateDiff([[Start],[Finish])\60) & Format(Abs(DateDiff("n",[Start],[Finish]) Mod 60),"\:00") This returns a Short Time( hh:mm) I have resolved the negative value problem using the...
  4. G

    New Member

    Hi- new member form Nottingham UK , I would like to introduce myself and look forward to learning from you all. Regards GarmaniNew Member
Top Bottom