Hi,

I have a table where i have 2 fields
i.e. date and second one is time

so whenever user is doing some transaction i would like to store date and time in these fields.

for date i got it from date.num()

but for time i found 2 functions i.e. time.num() and date.time.utc() which one should i use for captruing time ?? and what is the concept behind UTC ??

Regards

Learner

If you like to use utc, refer to the tools function -

utc.to.inputstr$() (http://www.baanboard.com/programmers_manual_baanerp_help_functions_date_time_zones_utc_to_inputstr)

Refer to the tools manual for more info on UTC -

Universal Coordinated Time (http://www.baanboard.com/programmers_manual_baanerp_help_functions_date_time_zones_overview)

You can also use time.num() and do the conversion to hours, mins and seconds.