AnsweredAssumed Answered

week number - day number

Question asked by kpg on Jul 2, 2013
Latest reply on Oct 30, 2013 by kpg


week number - day number


     Hi all

     I need help  with working with dates.

     I need to apply calculations based on dates but ... I use date in format: year, week number, day number

     How to prepare, define fields with data to be able to proceed calculation (deducting usually).

     In excell I have prepared 4 differend filds for that :YEAR, WEEK, DAY, Date (date fild was calculation to conwert those 3 numbers to a 'normal date'.

     But mayby in File maker is any easier way. Any way to define fild in a way that program will 'see it' as a date with possibility of making calculations?

     Thanks for all help