Forum Discussion
ChrisChris
7 years agoQrew Assistant Captain
try
If(
[Period Tested]=ToDate("01-01-2016"),1,
[Period Tested]=ToDate("02-01-2016"),4
)
SammySSammyS
7 years agoQrew Cadet
Thanks Chris and Dan, the ToDate() function worked fine in this scenario!