topic Re: I need shift field = Morning Afternoon Night in App Development

I need shift field = Morning Afternoon Night

Sxbbb — Fri, 15 Nov 2024 20:53:02 GMT

I have Field

Morning shift time 06.00-13.59 hrs. Afternoon shift 14.00-21.59 hrs. Night shift 22.00-05.59 hrs. I need shift field = Morning Afternoon Night I want to bring time TimeStartDowntime to TimeFinishDowntime is divided into shifts.

StartDowntime ='11:42:40' to FinishDowntime ='23:03:38'
The shifts are morning, afternoon, and night.

I need a field that displays values like this.

Re: I need shift field = Morning Afternoon Night

BrunPierre — Wed, 28 Aug 2024 10:35:01 GMT

Try this.

If(TimeStartDowntime >= PurgeChar(MakeTime(06,00,00),'AMP') and TimeFinishDowntime <= PurgeChar(MakeTime(13,59,59),'AMP'), 'Morning',
If(TimeStartDowntime >= PurgeChar(MakeTime(14,00,00),'AMP') and TimeFinishDowntime <= PurgeChar(MakeTime(21,59,59),'AMP'), 'Afternoon',
If(TimeStartDowntime >= PurgeChar(MakeTime(22,00,00),'AMP') and TimeFinishDowntime <= PurgeChar(MakeTime(05,59,59),'AMP'), 'Night' ))) as Shift

Re: I need shift field = Morning Afternoon Night

Sxbbb — Thu, 29 Aug 2024 02:02:36 GMT

No. Is there another way?

Re: I need shift field = Morning Afternoon Night

BrunPierre — Thu, 29 Aug 2024 09:04:39 GMT

Could you share a sample of the data?

Re: I need shift field = Morning Afternoon Night

Sxbbb — Fri, 30 Aug 2024 03:11:10 GMT

Re: I need shift field = Morning Afternoon Night

BrunPierre — Fri, 30 Aug 2024 07:02:51 GMT

Retry with this.

If((Time(TimeStartDowntime) >= Time('06:00:00') and Time(TimeStartDowntime) <= Time('13:59:59')), 'Morning',
If((Time(TimeStartDowntime) >= Time('14:00:00') and Time(TimeStartDowntime) <= Time('21:59:59')),'Afternoon',
If((Time(TimeStartDowntime) >= Time('22:00:00') and Time(TimeStartDowntime) <= Time('23:59:59')) or (Time(TimeStartDowntime) >= Time('00:00:00') and Time(TimeStartDowntime) <= Time('05:59:59')),'Night'))) as CheckPart_Shift