Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
PFA
My date format is as shown in attachment.
Can you please suggest how to date in DD-MM-YYYY format
Thanks
Hi,
try this:
=Date(date_field,'DD-MM-YYYY')
if the above don't work, you should know what is your date field source date format
Go to Data Manager than Table Overview
than click the Pen icon(Edit this table)
than click the field format (just above the field name)
Change the
Field Type,
Input format and
Display format
To test if the source data is really a date you can use:
Returns -1 (True) if the expression can be interpreted as a number, otherwise 0 (False).
Dates should return just like a number. This helps ensure that you have not inadvertently converted your "date" to a varchar representation of a date.
and maybe you can recommend him something to help him solve his problem?
Also, to ensure you retain the date-formating you should wrap your fields in the Date() function in your last load.
Date(SomeDate) AS SomeDate
** Please mark the comment helpful if it was useful in resolving your issue. Thanks! **
date(num#(YOURFIELD),'DD-MM-YYYY')