Lou Reyes Posted May 18, 2019 Share Posted May 18, 2019 One of the columns that's imported into my table is a Date/Time column in the format "5/17/2019 9:40:01 AM". I'm trying to create a calculated column that would stamp 'First stage', 'Second stage', 'Third stage' based on key time markers at 10:15 AM, 12:30 PM, and 2:45 PM. Have not been able to create a formula to achieve it... and when trying the functions Hour in combination with Minute... typically restricts it toa fixed hour slot. I thoughtthis was an easy task... but I seem to be overlooking something. Any thoughts are much appreciated! Lou Link to comment Share on other sites More sharing options...
Gaia Paolini Posted May 20, 2019 Share Posted May 20, 2019 you surround your date column and the cutoff with Time(..). Then use a case statement. Something like case when (Time([Mydate])>Time("10:30")) and (Time([Mydate])=Time("12:30")) and (Time([Mydate])=Time("14:45")) or (Time([Mydate]) 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