I want to use a case formula where the Date field contains the same info them 1 else 0.
I trued this one, but it does not work as expected.
Case
WHEN ([@field:Data]) = ([@field:Data]) THEN '1'
ELSE
'0'
END
Date column contains: dd/mm/year/ hours:minutes:seconds: The above formula just match for dd/mm/year/ and it does not consider time hours:minutes:seconds ( I would expected to have 1,1,0,0,0,0,0)
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
Mirko
I want to use a case formula where the Date field contains the same info them 1 else 0.
I trued this one, but it does not work as expected.
Case
WHEN ([@field:Data]) = ([@field:Data]) THEN '1'
ELSE
'0'
END
Date column contains: dd/mm/year/ hours:minutes:seconds: The above formula just match for dd/mm/year/ and it does not consider time hours:minutes:seconds ( I would expected to have 1,1,0,0,0,0,0)
How can I solve please?
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.