1 Reply Latest reply on Feb 15, 2013 3:17 AM by gcatnine

    Working with dates - how to conwert dayofweek+week day to normaldate

    kpg

      Title

      Working with dates - how to conwert dayofweek+week day to normaldate

      Post

           Hi

           I am working with a dates but not in 'normal date format' but I am using day of week + week number

           (4.2 = week no 4, tuesday, 7.5 = week no 7, friday)

           Working in european calendar Monday=1, Sunday=7

           I need to calculate length in days between those two days.
           How should I start? Should I have seperate kolumns for my dates and an extra for calculation with result?

           How to start?

           I did that in excel maby that could help to understand what I need

      excel.jpg

        • 1. Re: Working with dates - how to conwert dayofweek+week day to normaldate
          gcatnine

               If you use normal date fields to store the date, you can get very easily the week day and week number using the functions:

               WeekOfYear(date)

               DayOfWeek(date)

               To use Monday as start day of the week just do, may be as Custom Function:

               if ( DayOfWeek ( Date ) - 1 = 0; 7;  DayOfWeek ( Date ) - 1)

               And calculate the length in day between two date is just date2 – date1