Bhupinder K. Modi

1. Community
2. Workbooks & Analytics
3. Need to export null values to date column in SQL server

I am able to display null values in /mySql....Thanks for your help and guidance

• View comment
• Bhupinder K. Modi
• June 10, 2020 19:24
• 0 votes

1. Community
2. Workbooks & Analytics
3. Inserting data in workbook

Thankyou kindly  

• View comment
• Bhupinder K. Modi
• June 10, 2020 16:54
• 0 votes

1. Community
2. Workbooks & Analytics
3. Need to export null values to date column in SQL server

Hello Konsta   The exact version is 7.4.6   Report_Date is Date type and Report_Time is Time data type in Sql server..... I am a able to tansfer null using your logic...importing new data in workbo...

• View comment
• Bhupinder K. Modi
• June 10, 2020 15:48
• 0 votes

1. Community
2. Workbooks & Analytics
3. Inserting data in workbook

Thankyou for the code   QuarterYear should be dynamic usign the following logic from sql server (SELECT CAST(CASE WHEN month(getdate()) in (9,10,11) THEN 1 --12020 is availability date Oct/Nov/Dec...

• View comment
• Bhupinder K. Modi
• June 10, 2020 15:02
• 0 votes

1. Community
2. Workbooks & Analytics
3. Need to export null values to date column in SQL server

Thanks Konsta  All good here Hoping the same for you What Datameer version do you use?  Version 7 Do you see 1900-01-01 instead of null values in random columns or in a certain one? The date is sh...

• View comment
• Bhupinder K. Modi
• June 10, 2020 14:05
• 0 votes