Required Month and Year

[Srawat]

Hi Team,

Could you please help me to get the month & year in separate column from below date format. like- "June-2021".

Thanks,

[DataNath · Accepted solution]

Hey @Srawat, you should be able to use the following Formula tool expression to achieve the required format:

DateTimeFormat(DateTimeParse([EA-Datum],'%d.%m.%Y'),'%B-%Y')

[Srawat]

Thank you so much! It is working

[Srawat]

Hi,

I need one more quick solution, amount sum. Please refer below screen , I am unable to understand why not the row 2 is not totaling in column (C(A+B). Do I need to use some different formula? Please advise.

Thanks

[DataNath · Accepted solution]

Hey @Srawat, you can't add nulls and so for numeric fields you'll need to convert these to 0 before you can then use them in a Formula. The easiest way to do this without grabbing 3rd party tools/manually typing a Multi-Field Formula expression is to just use the Data Cleanse tool, ensuring the option to 'Replace with 0 (Numeric Fields)' is ticked:

[Srawat]

Thank you! It's working now.