Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
My date format is of MM/DD/YYYY HH:MM:SS
want to convert it into normal DD/MM/YYYY
How to achieve this..can anyone help me out
Thanks in Advanced
Hi
in your load script use
date(floor(DateField),'DD/MM/YYYY')
Rule is:
Date(Date#(YourValue, 'formatASis'), 'DesiredFormat')
This is assuming your date value is not really date but text. However, if you have a value which is really a date value (numeric values at the backend), you could just use outer date() and leave out date#().
hi,
i think it's best that you change the format from the system variables in the first page and then just simply use date(your_field).
Why? Because you may come across many Date Fields with different formats and when you are using them for expressions you may have problems getting the right expression with it's proper values.
hope it helps,
Andrei
first set date format in main script :
SET DateFormat='DD/MM/YYYY';
Use following code in your load script
load Date(Your_Date_Column_Name,'DD/MM/YYY') from your [Path]