date format

• Staggerlee

  SSCertifiable

  Points: 5272

  More actions

  November 9, 2011 at 4:22 am

  #250533

  Hi,

  I have a report that i want to see the last days results from and have the option for people to change the date to see further back if they wish

  The dates in the table are iso standard

  Ive set up a parameter and tried using:

  =DateAdd(DateInterval.Day,-1,Now)

  but it comes out in uk format so the results are messed up.

  Any ideas on a fix

  Thanks !

  S

• Staggerlee

  SSCertifiable

  Points: 5272

  More actions

  November 9, 2011 at 4:37 am

  #1405067

  Spoke to soon.

  Ive done the below exp and it seems to work!

  =Format(DateAdd(DateInterval.Day,-1,Now),"yyyy/MM/dd")

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  November 14, 2011 at 1:56 am

  #1406976

  stebennettsjb (11/9/2011)

  ---

  Spoke to soon.

  Ive done the below exp and it seems to work!

  =Format(DateAdd(DateInterval.Day,-1,Now),"yyyy/MM/dd")

  That is a great trick, I'll have to remember that 🙂

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP