I have an accountingperiod field, which is formated YYYYMM. For example 202405 would be May 2024. This is currently stored as an integer. How can i transform this accountingperiod field into a date field, so i can filter visuals by rolling date based on this field (which is a monthly period), oppos…

Turning an integer value into a date field

HarveyB-B June 3, 2024, 1:14pm 11

Breakdown of the solution:

Max date for each accountingperiod

I then formatted this as an actual date (concat to include ‘/’ between YYYY/MM/DD)

I then parsed this field as a date:

Topic		Replies	Views
How to convert string format YYYYMMdd to date Q&A formatting , date , calculations	7	2252	June 20, 2023
Date -12 digit integer to a date conversion Q&A formatting , error , date , Business-Intelligence-Engineer	14	79	September 23, 2024
Converting Date Field Data from YYYY-MM-DD into MMM-YYYY With Date Format only Q&A analysis , calculations	4	667	March 16, 2023
I want to convert a 6 digit integer to a date Q&A data-source	2	1119	March 7, 2022
How can I change period to format date? Q&A formatting , calculations	2	550	November 16, 2022