Post reply

Date v. Datetime

  • May 25, 2012 at 9:27 am

    #274698

    I am trying to get just the DATE part of now. In a report expression, how do I eliminate all the HH:MM:SS stuff and just get the mm/dd/yyyy 00:00:00

  • May 25, 2012 at 10:11 am

    #1493274

    Never mind, I finally got it.

    Instead of using Now in my expressions, I created a hidden parm called pToday. Its value is :

    CDate(datepart("m",now) + "/" + datepart("d",now) + "/" + datepart("yyyy",now))

  • May 25, 2012 at 4:45 pm

    #1493414

    huh:? if it is a textbox., format the properties of the texbox to date and pick the format you want. do that by right clicking the textbox. or FormatDateTime(Now, DateFormat.ShortDate)

  • June 2, 2012 at 8:50 pm

    #1496247

    Or in case your problem has not got resolved yet, here is another option that you can try...

    =Format(Now(),"MM/dd/yyyy")

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply