Calculated fields keep diappearing
Hello, I created two formula fields in a table that are used to extract the year and week number from the date codes in my original data set. However, these fields periodically show up blank in the...
Forum Discussion
I think this will help you to show the year and week directly in a single field
var number days = ToDays( [Date] -Today());
Year([Date])&"_"&Ceil(ToWeeks(Days($days)))
Replace Date with your date field
I hope this will solve your issue!!
var number days = ToDays( [Date] -Today());
Year([Date])&"_"&Ceil(ToWeeks(Days($days)))
Replace Date with your date field
I hope this will solve your issue!!