views:

147

answers:

0

Hello everybody,

My Case is, I have a sharepoint calendar list where I added a calcualted column to it. this column appends the value of the "created" field as a query string to a static URL for example, the calculated field formula should be like this,

"URL.aspx?XYZ="&[Created]

When The User uses this link, it will take him to a page in which I use this query string to retrieve the event information from the calendar list.

Now, The problem is that the output of the calculated formula is something like this, URL.aspx?XYZ=40210.2231597222

And I have no idea how to convert this format to the format that I can use in my SPQuery

I wish to hear from u

Note:I tried at the begining to use the ID field instead of "created" but I faced a known issue which is that the ID doesn't work correctly with the calculated column and it can't be read from the calculated column unless I make any update to the list.

related questions