Last year sameday

[nareshthavidishetty]

Hi ,

We need to copmare last year same day sales like..

Yesterday = 6/9/2016 = Thrusday (2nd week)

Last year sameday = 6/11/2015 =  Thrusday (2nd Week)

Thanks..

[MK_QSL]

You can simply subtract 52 * 7 = 364.

So,

Date(Date#('6/9/2016','M/D/YYYY')-364) as YourRequiredField

or

Date(Date#(YourDateField,'M/D/YYYY')-364) as YourRequiredField

[Anonymous]

Hi nareshthavidishetty,

Use function AddMonths:

Addmonths('6/9/2016',-12)='6/9/2015'

Regards!!