2022090920221114 i want this integer no to convet it into date like-Sep. 9 ’22 - Nov. 14 ’22

Hi @Siddhi_21 Please check the following images. They were tested with your dataset, and some values in the DATE2 field from your dataset are incorrect. [image] [image] Please refer the below pivot table documentation this might be helpful for you. [image] Super-charge…

Date -12 digit integer to a date conversion

Q&A

Siddhi_21 September 12, 2024, 3:31pm 11

aws…

this is the arena version

Ifelse query statement

Concat string column in integer along with % sign

Ifelse error with concate

Topic		Replies	Views
Parsedate with concat Q&A error , quick-sight , Business-Intelligence-Engineer	6	39	September 23, 2024
Brreaking down date format in quicksight using calculated field Q&A quick-sight	4	5739	October 27, 2021
Converting Date Field Data from YYYY-MM-DD into MMM-YYYY With Date Format only Q&A analysis , quick-sight , calculations	4	660	March 16, 2023
Convert numeric field to date Q&A analysis , formatting , feature-request , quick-sight , calculations	4	3706	April 28, 2022
How to convert string format YYYYMMdd to date Q&A formatting , date , quick-sight , calculations	7	2206	June 20, 2023

Date -12 digit integer to a date conversion

Related topics