Remove the date from a date time field / make formatting permanent

perhaps

variable = column_value mod 1

then format it to "h:mm AM/PM"

Originally Posted by dwint

perhaps

variable = column_value mod 1

then format it to "h:mm AM/PM"

Hi, can you explain what mod 1 does to the column value? I'm still learning so I want to understand fully what I implement.

Thanks!

actualy, date and time is as same as numeric, while integer is represent for each single date and decimal for hour & minute

when you devided your date & hour value with 1, and then you get decimal number.. its the time that your looking for

sorry, my english is not good.. i hope you understand what i mean.

Originally Posted by dwint

actualy, date and time is as same as numeric, while integer is represent for each single date and decimal for hour & minute

when you devided your date & hour value with 1, and then you get decimal number.. its the time that your looking for

sorry, my english is not good.. i hope you understand what i mean.

I somewhat understand what you mean. However, I'm not sure on how to implement this. I'm getting a type mismatch error :

Please Login or Register  to view this content.

Bump, can anyone help implement dwint's solution or have another idea?