week number - day number
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