https://community.sap.com/t5/technology-q-a/current-data-in-yyyymm-format-in-datasphere-view/qaa-p/13732618#M4833353 <P>Try this:&nbsp;TO_NVARCHAR(CURRENT_DATE,'YYYYMM')</P><P>&nbsp;</P> Mon, 17 Jun 2024 00:54:14 GMT Simon_Ye 2024-06-17T00:54:14Z https://community.sap.com/t5/technology-q-a/current-data-in-yyyymm-format-in-datasphere-view/qaq-p/13731135 <P>I'm looking for the best way to format the current date into YYYYMM in a Datasphere View format so for today it should be 202406. To I have to format it as a string first and then recoverd it to date with TO_DATE()?</P><P>Thank you.</P> Fri, 14 Jun 2024 13:03:25 GMT https://community.sap.com/t5/technology-q-a/current-data-in-yyyymm-format-in-datasphere-view/qaq-p/13731135 alexander_john_berlin 2024-06-14T13:03:25Z https://community.sap.com/t5/technology-q-a/current-data-in-yyyymm-format-in-datasphere-view/qaa-p/13732618#M4833353 <P>Try this:&nbsp;TO_NVARCHAR(CURRENT_DATE,'YYYYMM')</P><P>&nbsp;</P> Mon, 17 Jun 2024 00:54:14 GMT https://community.sap.com/t5/technology-q-a/current-data-in-yyyymm-format-in-datasphere-view/qaa-p/13732618#M4833353 Simon_Ye 2024-06-17T00:54:14Z