We’re rewarding the question askers & reputations are being recalculated! Read more.

New answers tagged

0

You can create a new calculated column named cal1 with the formula as : =TEXT(DateAndTime,"hh") Then edit your original calculated column with the formula as: =IF(cal1="00","24:"&TEXT(DateAndTime,"mm:ss"),TEXT(DateAndTime,"hh:mm:ss")) "DateAndTime" is a date column that you get date and time information. the formula means if the cal1 column return ...


0

You can try with this formula: =CONCATENATE(IF(AND(DAY([MyDate]) > 28, MONTH([MyDate]) = 12), YEAR([MyDate]) + 1, YEAR([MyDate]))&"-"&IF(DAY([MyDate]) > 28,IF(MONTH([MyDate]) = 12, 1, MONTH([MyDate]) +1), MONTH([MyDate]))) Just change [MyDate] to whatever is your date column's name.


0

I tested in my end and the column works just as Ganesh showed. Also i tried with semicolon which pops with syntax error. Besides the possible language reason, try with a new column or new list to see if the issue remains.


1

In order to create a calculated column as a date you need to use your formula in below format: =DATE(YEAR,MONTH,DAY) Using the formula as you have added in question, I am able to create a calculated field which will be in date format. see below: Note: I have return this field as Date and Time (highlighted in above image). Sometimes comma(,) does not work ...


1

You need to set the Visible property of your Paid Date field based on the value of your field Stage. To check the value of Stage is equal to "Stage 7" or not, you need to use IF function. You need to use your formula in Visible property of Paid Date field something like below: IF(Stage.Value = "Stage 7", true, false) Also, another way is to use Variable ...


Top 50 recent answers are included