https://community.qlik.com/t5/App-Development/Date-AM-PM/m-p/1892657#M73583 <P>hour(date(my_date)) as my_hour,=&gt; automatic transform in the good AM or PM</P> Mon, 14 Feb 2022 16:09:39 GMT ALEX1977ALEX 2022-02-14T16:09:39Z https://community.qlik.com/t5/App-Development/Date-AM-PM/m-p/1892653#M73582 <P>Hello</P> <P>i have this format date</P> <P>10/19/2019 6:23:26 AM</P> <P>How can i check if date is AM or PM</P> <P>i tried with right(my_date,2) but it s a format date so it was wrong</P> <P>how can i modify in order to have a text format in order to&nbsp; have a text format?</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 14 Feb 2022 16:01:54 GMT https://community.qlik.com/t5/App-Development/Date-AM-PM/m-p/1892653#M73582 ALEX1977ALEX 2022-02-14T16:01:54Z https://community.qlik.com/t5/App-Development/Date-AM-PM/m-p/1892657#M73583 <P>hour(date(my_date)) as my_hour,=&gt; automatic transform in the good AM or PM</P> Mon, 14 Feb 2022 16:09:39 GMT https://community.qlik.com/t5/App-Development/Date-AM-PM/m-p/1892657#M73583 ALEX1977ALEX 2022-02-14T16:09:39Z