+ Reply to Thread
Results 1 to 1 of 1

Date time syntax query in vba

  1. #1
    Forum Contributor
    Join Date
    01-29-2011
    Location
    Pakistan
    MS-Off Ver
    Excel 2013
    Posts
    256

    Date time syntax query in vba

    Hi All,

    I am able to get the just time via below syntax please alter it i want the date also in in currently it showin hours i need format like

    dd/mm/yyy HH:MM:SS


    CONVERT(Varchar, DATEPART(HH,START_DATETIME))+':00'


    Thanks and Regards,
    Farrukh Hameed
    Last edited by farrukh; 06-15-2012 at 03:49 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1