Forum Discussion

netanel's avatar
netanel
Post Prodigy
3 years ago
Solved

ISO DATE

Hi All,   To get the ISO Date for Year and Week i wrote the following formula: ISOYear-WeekNumber = FORMAT(YEAR([FullDateAlternateKey]) & "-" & WEEKNUM([FullDateAlternateKey], 21),"0000-00") ...