Hi expert,
I need to support as per slab wise data. Like,
Time 00:01 am to 02:15 pm “before”
02:15 PM to 11:59 pM “after”
Please guide how i can?
BR
Sultan
Extract the time from your date/time field and use an if then statement to group into your categories.
= if formatdate( [datefield] ; “HH:mm:ss”) between “00:00:00” and “14:15:00” then “Before” else “After”
Hi dtolley,
I tried as per your guide. But stll getting error. Missing or bad operand in between expression at position 43 ( IES 10070).
Screen shot is attached
Pls guide.
BR
Sultan
The first “else” should be “then”
if formatdate( [Time=24] ; “HH:mm:ss” ) between “00:00:00” and “14:15:00” then “before” else “after”
Sorry, brain is on weekend mode. It’s between( "00:00:00 ; “14:15:00” )
1 Like
- have a look at the SAP-formula-documentation/syntax by yourself
- try to solve the problem by yourself with reducing the complexity step by step to find your error
- use >= and <= instead of between
or use timebetween() or datesbetween() when comparing date/time-formats
1 Like
Sorry I am not aware so much. I am using time data base.
Could you share formula.
After formatting a date/time with the formatdate function, the result is a string, not a date/time. The time or date between functions won’t work. It’s also not the appropriate function for the result the OP is looking for. They are doing a value comparison, not calculating a difference between two date/times.
They need to use between or >= and <=.
What data type is Time - 24? Is it date and time?
Hi markp
Time-24 is variable field
=formatdate(relativedate(todate(formatnumber(max(([date]*1000000) +[time];“0”) ;“yyyyMMddHHmmss”) -2. 5/24) ;“dd:MM-yyyy”)
pay attention to the parenthesis and date-format.
i don’t think there will be a correct result come out here
What are you trying to calculate and what format are [date] and [time]?