Jump to content

Megpiri

Members
  • Content Count

    1
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Megpiri

  • Rank
    Newbie
  1. I'm trying to change the date format in the below query to MM-01-yyyy but when I change it throws up an error. HELP! - Thanks cast(format(transdate, 'yyyy-MM-01') as Date) as 'Start Date', eomonth(cast(format(transdate, 'yyyy-MM-01') as Date)) as 'End Date', 'Mobile (ex)'as 'Type of Expense', CASE left(general2,8) WHEN 'Outgoing' THEN 'Mobile Phone Charges - ' WHEN 'Incoming' THEN 'Mobile Phone Charges - ' WHEN 'Parking ' THEN 'Parking Charges - ' WHEN 'Landline' THEN 'Landline Phone Charges - ' ELSE 'DATA - ' END + datename(month,ca
×
×
  • Create New...