case
when [@field:follow_checkbox] = 1 and [@field:when_to_follow] !=(SELECT CONVERT(VARCHAR, CONVERT(DATE, GETDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Egypt Standard Time'), 103) AS [Date_Result])
then " yes"
else " no "
end
it supposed that if a checkbox is checked and another field date is not equal todays date ( in format 103 ) it shows yes else no
but for some reason the calculation doesnt work and it shows no all the time
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.
Question
DRAhmed
i have a calculated field like this
case
when [@field:follow_checkbox] = 1 and [@field:when_to_follow] !=(SELECT CONVERT(VARCHAR, CONVERT(DATE, GETDATE() AT TIME ZONE 'UTC' AT TIME ZONE 'Egypt Standard Time'), 103) AS [Date_Result])
then " yes"
else " no "
end
it supposed that if a checkbox is checked and another field date is not equal todays date ( in format 103 ) it shows yes else no
but for some reason the calculation doesnt work and it shows no all the time
Link to comment
Share on other sites
4 answers 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.