Skip to main content
Topics#Data ManagementPregunta de Abigail Sanchez
Abigail Sanchez (Auth0) ha preguntado en #Data Management
14 sept 2018, 15:04

Formula to Return Text for Created Time Range

I'm trying to write a formula field to sort cases into regions based on what time the case came in. How do I return these values based on Date/time created

 

GMT 23:00-7:00 = APAC

 

GMT 7:00-15:00 = EMEA

 

GMT 15:00-23:00 = AMER
2 respuestas
  1. Sunil Sarilla (M&G Investments)
    14 sept 2018, 15:31
    Hi Abigail,

     

    Please try the below

    IF(
    AND(
    VALUE( MID( TEXT(CreatedDate), 12, 2 ) )>=7,
    VALUE( MID( TEXT(CreatedDate), 12, 2 ) )<15
    ), 
    'EMEA',
    IF(
    AND(
    VALUE( MID( TEXT(CreatedDate), 12, 2 ) )>=15,
    VALUE( MID( TEXT(CreatedDate), 12, 2 ) )<23
    ), 
    'AMER','APAC')
    )
Escribir una respuesta...
0/9000