Date formats

AlphaVAT uses the date of a transaction in a number of places. For example, in the calculation itself, for out-of-period transaction checks, and when filtering data.

When uploaded, the format of all the data in the column must be in an accepted date format. AlphaVAT uses the UK date format DD/MM/YYYY.

Where data is uploaded that is a date, but not in the UK date format of DD/MM/YYYY, AlphaVAT will convert the format during upload. For example, if a file is uploaded with dates in the format DD-MM-YY, this will be converted in AlphaVAT to DD/MM/YYYY.

AlphaVAT does not currently accept dates in non-UK formats, for example US formats of MM/DD/YYYY. If columns containing non-UK dates, or non-dates are mapped to AlphaVAT’s date input, you will not be able to proceed and you will see the following error:

Non-dates must be removed from the column before a calculation can be run.

SECTION CONTENTS

PREV

NEXT

BACK TO MAIN