Change date format for Data conversion

[Megpiri]

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,cast(format(transdate, 'yyyy-MM-01') as Date)) + ' ' +
    + CAST ( YEAR(cast(format(transdate, 'yyyy-MM-01') as Date)) as varchar)

[Makwana Prahlad]

Hello, @Megpiri

Please try this query,To Change date format for Data conversion:

select convert(varchar,getdate(),107) as "Date"

I hope above query will be useful for you.

Thank you.