Finding first date in hana graphical calculation view

[karthik1993]

Can anyone tell me how to calculate first date of a month in hana graphical calculation view? EX: 23-07-2018 should become 01-07-2018

[pfefferf · Accepted solution]

You can create a calculated date column which uses the component function to extract the month and year of your date. As the beginning of the month is always 1, you have then all components to create build the new date. If your current date is not in a date format, you can use conversion function date to convert your value into a date.

Regards,
Florian

[former_member457784]

You can create a calculated column with datatype as Date.

Please paste the below code in the expression editor.

date (format("CREATEDON",'YYYYMM'))

[former_member302041]

ADD_MONTHS(NEXT_DAY(LAST_DAY(YOUR_DATE_FIELD)),-1)