AM / PM Calculation

Badeschlapfen

Hi all,

I'm having the following problem:

I would like to calculate a field for AM / PM based on the survey time.

I used the following code in the calculation column (where ${SurveyDate} = now()): 

if(decimal-time(${SurveyDate})<0.5,"AM","PM") 

This works perfectly fine for the mobile version

 

However, for the web version, it returns always PM regardless of the time. 
Is this a UTC offset issue? 

Does anyone have an idea how to solve this issue?
Thank you

IsmaelChivite

if(format-date(${wsdatetime},'%h')<12,"AM","PM")   This expression will work if wsdatetime is a datetime question