Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Trying to filter for YTD with yyyymmdd

Status
Not open for further replies.
dmccallum

dmccallum

Programmer
Jan 5, 2001
90
US
I have a database where del_date is a string in the format of yyyymmdd but I need to sum a field for YTD. How can I convert my date so that it is recognized by the YTD function? I've tried:

WHERE (Del_Date = 'jobcost".del_date} in YearToDate')

among other ways.
 
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
for strongm site down?
Replies
3
Views
343
strongm
strongm
marty1944
  • Locked
  • Question
error code 380 when trying to run the visual basic v6 deployment wizard
Replies
1
Views
831
marty1944
marty1944
sal21
  • Locked
  • Question
FILL RICHTEXTBOX WITH RECORDSET
Replies
4
Views
535
strongm
strongm
sal21
  • Locked
  • Question
NOT FOR ME, get value from table web
Replies
1
Views
244
sal21
sal21
Swi
  • Locked
  • Question
Printer.Print to PDF 1
Replies
16
Views
1K
Swi
Swi

Part and Inventory Search

Sponsor

Back
Top