Liliana Member

Thanks Grant!

Thank you @tejusarora and @MichelleH for your answers. I will try your suggestions.

As a time stamp i got the example above. I changed it to text and now i got this: I need to get it in this format: Thanks again Grant.

Thanks Grant for your prompt answer. My date is formatted as date. After I combined the date and time, i changed it to timestamp.

Thanks @GrantSmith for your response. This is more than I thought. Appreciate it

Thanks, Jae I need to track payment by insurance and patients. I created the ETL , unpivot the data then created a table in SQL to bring some information over that I was not able to get in ETL. It worked with the unpivot as Grant and Mark recommended. However, now I am trying to create a total paid column (patient paid…

Thanks Grant and Mark, it worked. Appreciate your help and quick response.

Thanks Jay!

Thanks again Mark and Jay. I followed your advice and it work!

Thanks Mark and Jae for answering, I will try it and will let you know.