Date conversion to String with Format(DD/MM/YYYY)

[HITESH SAHOO]

Hi All,

I have to embed calculated column in textarea where inspection_date is Date type column with formatting "DD/MM/YYYY". And also value should be '-' if any it is null.

Below is my logic in calculated column, but using String() changes date format from DD/MM/YYYY to MM/DD/YYYY.

SN(String(First([inspection_date])),"-")

 

So is there any way to fix this

Thanks in advance.

[Shashank Gurnalkar]

Instead of using String(First([inspection_date])), can you try to use this expressionand see if it helps:

Concatenate(String(Day(First([inspection_date]))),"/",String(Month(First([inspection_date]))),"/",String(Year(First([inspection_date]))))

[HITESH SAHOO]

I would also need to replace values with "-" if there is null value. 

 

So, if I use SN with above code, it gives "//" where there is null. 

 

 

[Shashank Gurnalkar]

You can use If loop with a condition. Let's call the above expression as X. FOllowing would be the expression:

 

If(X="//","-",X)

 

[HITESH SAHOO]

Thank you so much for your help. It worked.