You need to sign in to do that
Don't have an account?
Daniel Ferrara
Hour of the Day Formula 0 to 23 not working
This formula does not work for entire 24 hour clock in Pacific Time Zone.
CASE(MID ( TEXT (CreatedDate), 12, 2),"01",1," 02",2,"03",3,"04",4,"05",5,"06",6,"07",7,"08",8,"09",09,"10",10,"11",11,"12",12,"13",13,"14",14,"15",15,"16",16,"17",17,"18",18,"19",19,"20",20,"21",21,"22",22,"23",23,"00",00,Null)-(7)
CASE(MID ( TEXT (CreatedDate), 12, 2),"01",1," 02",2,"03",3,"04",4,"05",5,"06",6,"07",7,"08",8,"09",09,"10",10,"11",11,"12",12,"13",13,"14",14,"15",15,"16",16,"17",17,"18",18,"19",19,"20",20,"21",21,"22",22,"23",23,"00",00,Null)-(7)
Try this:
Please let me know if this will work. I trust it will.
Thanks
Gulshan Raj
All Answers
Can you please let me know what is your requirement?
Thanks,
Neetu
Try this:
Please let me know if this will work. I trust it will.
Thanks
Gulshan Raj