Date Format/Calculated Value question

  • 19 March 2018
  • 1 reply
  • 4 views

Badge +8

I can't believe I'm having an issue with something like this. It should be very simple and I'm sure I am just missing something.

I have two drop down choices. One is a list ranging from 01 to 12, to represent the month. Another is the four digit year. 

The idea is you select the month, then the year, then in a calculated value I combine them.

Example: For today, it should show "03/2018". Except when I use the formula "choiceServiceMonth/ChoiceServiceYear" I get an error which I assume is because it's trying to divide the numbers. When I used a dash instead of slash, it subtracted 03 from 2018 and showed me 2015. What's the trick here that I'm missing?


1 reply

Badge +8

Should not have taken me this long to figure this out haha.

choiceServiceYear + "/" +  choiceServiceMonth

Reply