Tag Info

Hot answers tagged

1

You need two calculated columns and apply filter Start of the Month =DATE(YEAR(DateField),MONTH( DateField),1) End of the Month =DATE(YEAR( DateField ),MONTH( DateField)+1,1)-1 Filter "Start of the Month" is Less than or Equle to [Today] Or "End of the Month" is Greater than or Equal to [Today]


1

A formula like this should do the trick. =CONCATENATE(MONTH(DATE_FIELD_NAME),"/1/",YEAR(DATE_FIELD_NAME))


1

Try this formula: =CONCATENATE(MONTH([Date]),"/1/",YEAR([Date]))


1

=[START DATE]+[ETC] + ROUNDDOWN([ETC]/5,0)*2 + IF(WEEKDAY([START DATE])+MOD([ETC],5)>=7,2,0) - ROUNDDOWN(WEEKDAY([START DATE])/7,0) + IF(AND(MOD([ETC],5)=0,WEEKDAY([START DATE])=1),-2,0) + IF(AND(MOD([ETC],5)=0,WEEKDAY([START DATE])=7),-2,0) Here's where I copied this from.


1

Create a calculated column and set the return type to Single line of text. If the URL path until Arizona is constant, then add the below formula =LEFT(RIGHT([Column Name],LEN([Column Name])-36),FIND("/",RIGHT([Column Name],LEN([Column Name])-36))-1) Replace the column name and Number "36" based on the number of characters before the text "Arizona".


1

I found the problem - the result of the calculated column was being formatted in Inforpath as text and not as a decimal. For future reference, this can be changed like so:



Only top voted, non community-wiki answers of a minimum length are eligible