I previosuly used SQLT on computed fields. This now longer appears to work. I believe the new syntax is PosdtgreSQL. Can you tell me how I can extract the week from a date in a computed field? Also how can I display today's date. I can displat the timestanp using 'now()' but I can't figure out how to extract just the date portion.
Thanks for you help,
Solved! Go to Solution.
You can extract the day as a string by using the following formula: to_char(FIELD_NAME,'dd').
However, if the target data type is numerical, use the following formula: to_number(to_char(FIELD_NAME,'dd'),'99').
Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register