Martin Campos Posted December 27, 2020 Share Posted December 27, 2020 Im trying to do this in calculated column: case when [sNAPSHOT_DATE]=date(08,11,2020) then [NO_ROOMS] end I want it to assign or separate the values of NO rooms in the new column with the date (11/08/2020) but it doesn't, I don't know what the error is Link to comment Share on other sites More sharing options...
Gaia Paolini Posted January 4, 2021 Share Posted January 4, 2021 I think the order of the input parameters in the Date() function is year, month, day. Try with: case when [sNAPSHOT_DATE]=date(2020,11,08) then [NO_ROOMS] end Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now