MHDslagelse Posted January 21, 2018 Report Share Posted January 21, 2018 Hi I'm trying to make a formula field showing the week number for a date Using this code Datepart(week,[@field:KampDato]) But it says invalid formula If I change week with year it work ok, but week must work I think. In your onlline help it is supposed to be ok https://howto.caspio.com/function-reference/ Quote Link to comment Share on other sites More sharing options...
1 Vitalikssssss Posted January 22, 2018 Report Share Posted January 22, 2018 Hi MHDslagelse, Please note that Datepart(week) function is not supported in Formula field because it is non- deterministic. You may use the workaround described in this post . Regards, vitalikssssss MHDslagelse 1 Quote Link to comment Share on other sites More sharing options...
Question
MHDslagelse
Hi
I'm trying to make a formula field showing the week number for a date
Using this code Datepart(week,[@field:KampDato])
But it says invalid formula
If I change week with year it work ok, but week must work I think.
In your onlline help it is supposed to be ok
https://howto.caspio.com/function-reference/
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.