Hey guys,
I have taken a stab at this, but I seem to be stuck. My problem is that I hate using relational packages but anyway - I am trying to calculate YTD amount based on a prompted period which has YYYY-MM, but the data type isn't date/time it is characterlength 16; so none of the date functions are working. I even tried starting with just pulling Prior Period(month) but no luck there. I've used extract, add_months, <=?month? to get months in the year by trying to extract the year, and also _round(?month?/100, 0) and none of it is working.
I would try to use another item that has data type date/time, but this one is required.
Any suggestions would be greatly greatly appreciated!!! ;D
Thanks!!
Hi,
You might find it more straightforward to convert the item to a date datatype using the _make_Timestamp() function - you can plug in the year and month from your parameter and specify 1 as the day part. This should then enable you to use all the nice date functions :-)
Regards,
MF.
Thanks so much for the reply! I will definitely try that.:)