HITESH SAHOO Posted April 13, 2020 Share Posted April 13, 2020 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. Link to comment Share on other sites More sharing options...
Shashank Gurnalkar Posted April 13, 2020 Share Posted April 13, 2020 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])))) Link to comment Share on other sites More sharing options...
HITESH SAHOO Posted April 14, 2020 Author Share Posted April 14, 2020 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. Link to comment Share on other sites More sharing options...
Shashank Gurnalkar Posted April 14, 2020 Share Posted April 14, 2020 You can use If loop with a condition. Let's call the above expression as X. FOllowing would be the expression: If(X="//","-",X) Link to comment Share on other sites More sharing options...
HITESH SAHOO Posted April 14, 2020 Author Share Posted April 14, 2020 Thank you so much for your help. It worked. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now