DayOfWeek to Date

Discussion created by cmj on Dec 31, 2018
Latest reply on Jan 1, 2019 by cmj

I would like to reference a field that contains a date e.g. Thursday Jan 3, 2019 (01/03/2019) and use the DayOfWeek from that date to arrive at the first Thursday (or what ever the DayOfWeek ) that occurs in a later year such as 2020.


Date(1;DayOfWeek(ref field date);2020) returns the 5th of Jan 2020, whereas the first Thursday in Jan 2020 is Jan 2nd.


Thanks and Happy New Year!