Saving date with time in one field

mike_espina

experts,

how do I save a date with its corresponding time in one field. the today() function as well as the systemdateget() function only saves the date and not the time. I need a function that will get the date and time in one function and to be able to save it in one field.

Pls help me.

Mike

Miker

Hi Mike. At first, how you are intend to store this mega format. Dax and Axapta has only date and time field format. Second, you should make own EDT for this case. Third make function for consistent data in your new format

mike_espina

hi.. I was wondering becuase when I see te backend of the database the date fields have time in it but only 00:00:00. in all date field in axapta it has this format on the backend. I was wondering if we can also save the time in it. Just like in VB if you call the function "Now" it will get you the exact date and the exac time and once you save it in the database it will be save as the date with the current time in it. It will look like this in the backend "07/31/2007 07:21:12".

can axapta do this?

thanks

Mike