Tag Info

New answers tagged


This will give you the format 2013-2014, 2014-2015: =IF(MONTH(Created)>6,YEAR(Created)&"-"&YEAR(Created)+1,YEAR(Created)-1&"-"&YEAR(Created)) It takes MONTH>6, so you could adjust that parameter for fiscal start. And for FY 2014, FY 2015 etc, you could use this formula: =IF(MONTH(Created)>6,"FY "&YEAR(Created)+1,"FY ...


There is property called DefaultValue. $FieldName = $list.Fields["NH Department"] Write-Output $("NH Department - Default Value " + $FieldName.DefaultValue)


This formula should work: =IF(DATE(YEAR(Created),10,1)>Created,YEAR(Created),YEAR(Created)+1) This is an adaptation from this link. Created is a column that stores what the name implies. I hope this helps.

Top 50 recent answers are included