Date-Time Issue

tonypangtonypang Member Posts: 101
Hello now i having the issue to chop the date value show in the form.
Example :
A = 16/12/2010 10:29 AM

I need to return result as 16/12/2010 show in the form instead of show full value.

Does any body know how to do it ?



  • Options
    mark_aumark_au Member Posts: 40
    If you're talking about C/AL Code, all you need is the DT2DATE Function:


    Pass in a DateTime and it will return the Date section of it. Similarly there is a DT2TIME Function which, obviously, returns the time part of a date time :)
  • Options
    manishgoyalmanishgoyal Member Posts: 52
    by using Format function you can do it. and by default date and time format depend on your system.
    Manish Goyal
  • Options
    krikikriki Member, Moderator Posts: 9,098
    [Topic moved from 'NAV Three Tier' forum to 'NAV/Navision Classic Client' forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Options
    tonypangtonypang Member Posts: 101
Sign In or Register to comment.