I have this date set uploaded from SAS to TD and the date format is like MEDI_START_DT format,'MM/DD/YYYY' And now I want to make a calculation baesed on this column MEDI_START_DT + PDAYSSUP -1 = MEDI_END_DT_PRE but MEDI_END_DT_PRE's format is not a date and I tried cast(MEDI_END_DT_PRE's as date) and it says invalid date. Do you guys have any idea on how to get a date format result after the calculation? Thanks!
Related Questions in DATE
- Using JQuery Date Slider
- Get Type Error when using .countDocuments with mongoDB
- Gsheet - Automatically send an email using a date & time in a Cell
- Market share growth versus last month, last year
- Convert date string into a number in Python
- Date formatting "yyyy-MM-dd hh:mm:ss +0000" to "dd MMM" in swift
- How does Big Query differentiate between a day and month when we upload any CSV or text file?
- Event_date reference in CTE
- Laravel Nova 4 format date in BelongsTo field
- how to count days elpased between each interval using mySQL?
- MariaDB incorrect dates
- Date issue - how do I parse date in this SQL
- Countdown to varying payday in Javascript
- Can I have a static ISO8601DateFormatter with specific formatOptions in Swift?
- Date Format mdy vs dmy
Related Questions in FORMAT
- C++: Prevent method from expanding too early when passed as argument
- I am using the bash terminal in VS Code, I am new to coding, and the terminal displays very differently, how do I get them to match?
- How to assign a value to a string variable, that includes embedded '=' in the value
- VSCode not autoformating R lintr suggestions
- How to preserve json file format when writing a file
- Python search for the errors in the JSON
- Combine an audio and a text file as one single file
- SSRS - Do not want to round a percent
- Date Format mdy vs dmy
- command in bash contains printf but the format is not hand over to variable
- How can I change the dateformat of dateColumn in react-datasheet-grid
- How to format float to omit zeros at the end of the fraction
- R for loop to display mean and max of each row in a matrix
- Formatting IMF IFS data in R
- Having trouble setting x-axis endpoints in proc univariate
Related Questions in TERADATA
- Kafka Connect JDBC Connector not working with teradata
- Spool Space Error while using LEFT JOIN in TERADATA
- Teradata query to Calculate Start and End dates Based on a condition
- whether it is possible to overwrite the result of the UNION operation to the name of the first table
- Failure 2673 The source parcel length does not match data that was defined
- Dynamic starting position in substring and dynamic length
- How to set default role for Teradata User?
- How can I create a secure connection with teradatasql
- issue with case statement
- Visual Studio 2022 connection to Teradata ODBC Driver 17.10 from Server Explorer
- Sql - Rolling up multiple rows to one row
- issue with QUALIFY RANK
- SSIS Teradata connection not appearing when creating new connection manager
- Exception criteria exceeded : CPU time in SAS . How to resolve this error?
- Query usage metadata from Teradata
Related Questions in DATE-FORMAT
- Crash parsing date strings but only on some iOS devices
- change java.util.Date format
- JQuery Datepicker display date format
- MySQL STR_TO_DATE returns NULL when using week number directive (%U, %u, %V or %v)
- converting date to new format not working using strtotime()
- d3js Dateformat: Hours, Minutes and Seconds incorrect
- Trying to show only year from a date stored in mongodb database. How to do that?
- Convert date column to date format and extract month and year
- XMLGregorianCalendar with 6 milliseconds
- Microsoft dateformat add 1 to yyyy
- Trim and Format Date Axis Formatting for Dataframe in HeatMap
- to get the instance count of a certain period via LaunchTime wrt Powershell
- Java 11 ZonedDateTime - Print Format
- Getting 0 results when I use BETWEEN DATEADD(MONTH,-4,CURRENT_DATE) AND DATEADD(MONTH,-1,CURRENT_DATE)
- Unable to convert String to LocalDateTime format "YYYYMMDDhhmmss" (week year) pattern with (day of month)
Related Questions in CALCULATION
- How to calculate the accuracy in number guessing game?
- Creating Bezier curves that meet curvature condition
- I need something similar to a recursive function to dynamically update "Amount Due" fields for a debt payment plan in Google Sheets
- what is the formula for excel when cell value changing from 0 to 1, the calculation formula in next cell will start
- How to write formula for SIP calculator in javascript
- Can I have a plotshape plotted during realtime bar when using calc_on_every_tick?
- Float calculation problem. 12.7 - 20 + 7.3 not equal zero
- c++ calculations are un-understandable
- How to convert HTML "span" + "input" elements to Number?
- Dynamic Constant Line in PowerBI Line Chart
- Calculate hex color with transparency based on other colors
- metpy divergence module array indexing error
- How do I show data in Tableau up to the current day in previous years for a financial year that starts in July
- Contour Integration with Sympy Vector: Discrepancy in Result
- Jexl arithmetic calculations are not accurate
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
If you loaded the data from SAS and it was formatted as a DATE in SAS then it should work. You should check if your
PDAYSSUPvariable got defined asFLOATin Teradata. Try casting that variable: