locked
Converting Dates as paramters RRS feed

  • Question

  • Hey guys,

    Hoping i can get some help with this one..  

    Problem:

    Data source has a datetime format as YYYYMMDD

    I would like to have my users enter a date in the format of DD/MM/YYYY and in the background have it convert to the YYYYMMDD so i can filter my data according to the data

     

    ANy ideas on how i will do this??

     

    thanks

     

    scotty

    Tuesday, June 13, 2006 2:35 AM

Answers

  • Use Format function and convert the date parameter to required format.

    Format(Parameters!prmStartDate.Value, "yyyy-MM-dd")

    Tuesday, June 13, 2006 8:59 PM