Post reply

Prevent time from being displayed on DateTime parameter

  • June 15, 2010 at 12:18 pm

    #236452

    I'm trying to find a way to utilize the calendar date picker but not display the time on the screen.

    The only choice for parameter type is datetime.

    I cant believe that there isnt a choice for Date as a parameter type.

    I really do not want to have to go the route of creating a string type parameter that only accepts dates.

    This should be easier.

  • June 16, 2010 at 6:51 am

    #1180926

    Ok, I figuired out a solution.

    You need to convert the DateTime into ShortDate string format and then convert it back to a Date. The example code I posted also picks a date 30 days ago.

    =DateValue(FormatDateTime(DateAdd("d",-30,Now),DateFormat.ShortDate))

    I guess no one in Dev thought that people would want to be able to view a calendar date picker without a time.

Viewing 2 posts - 1 through 1 (of 1 total)

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