Please can someone help me with the below?  I have a current date field in epoch time which I need to convert to display in a Crystal report.  I have done that using:

 

DateAdd ("s", {emm_Image.backuptime}, #1/1/1970# )

 

which works fine.  This field is then used in a cross tab report and displays every date entry.  However I want the cross tab to only display dates which are a Friday, not all the dates recorded.

 

Does anyone know how to do this?

 

Thanks in advance.

I have added it to my string so it looks like this:

 

DateAdd ("s", {emm_Image.backuptime}, #1/1/1970# ( dayofweek({emm_Image.backuptime}) = 5))

 

but I am getting an error saying the ) is missing.  Please can you give me the whole string - sorry, scripting is not my strong point...

 

Thanks in advance.

 

{@backuptime} in {?Start Date} to {?End Date}

 

so I can specify a date range.

 

How do I add that to the above?  Sorry, as you can tell this is not my strong point....

emm_image.backuptime is in epoch time and errored saying 'a date is required here' so I changed it to:

 

 {@backuptime} in {?Start Date} to {?End Date} and
dayofweek({@backuptime}) = 5

 

which works perfectly....