Validating Dates In A TI Process
Posted: Wed Mar 07, 2018 2:18 pm
Hi,
Just want to confirm something about dates in TM1.
I have a TI process that includes a couple of parameters for start and end date.
On the web the user inputs a start and end date.
I was hoping I could use the DayNo function to test if the dates were valid and processquit if they weren’t. However I notice that if I put in an invalid date, such as 29 February 2018 the dayno function returns the serial number for the 28 February 2018, rather than throwing up an error.
So it seems TM1 does some conversion with dates. Can anyone verify this and are there other examples of such conversions in TM1?
Incidentally I got round the problem of validating the dates by validating them on the websheet, so I have a new parameter, pValidDate and if a cell on the websheet shows invalid the process errros saying the dates are invalid!
cheers, Mark
Just want to confirm something about dates in TM1.
I have a TI process that includes a couple of parameters for start and end date.
On the web the user inputs a start and end date.
I was hoping I could use the DayNo function to test if the dates were valid and processquit if they weren’t. However I notice that if I put in an invalid date, such as 29 February 2018 the dayno function returns the serial number for the 28 February 2018, rather than throwing up an error.
So it seems TM1 does some conversion with dates. Can anyone verify this and are there other examples of such conversions in TM1?
Incidentally I got round the problem of validating the dates by validating them on the websheet, so I have a new parameter, pValidDate and if a cell on the websheet shows invalid the process errros saying the dates are invalid!
cheers, Mark